Results 1 to 5 of 5

Excel Macro that will convert phone #s

Threaded View

  1. #1
    Registered User
    Join Date
    03-27-2009
    Location
    Kansas City, USA
    MS-Off Ver
    Excel 2003
    Posts
    2

    Excel Macro that will convert phone #s

    I'm needing a macro that will convert a column of 10 digit phone numbers and break them out or convert them from a XXXXXXXXXX format to a XXX XXX XXXX format.

    I want to be able to copy and paste a long column of 10 digit numbers then have the macro run down the column and cut or copy the area code (first 3 digits of the 10 digit string) - move it two columns to the left - paste it into that cell - return then cut the next 3 digits - move it one column to the left, and paste it.

    Much thanks in advance!

    Workbook >

    http://www.mediafire.com/?sharekey=e...4e75f6e8ebb871
    Last edited by rylo; 03-28-2009 at 07:58 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1