Excel Macro that will convert phone #s

[kcbjordan]

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

[rylo]

Hi

Try this.

Please Login or Register  to view this content.

rylo

[Ron Coderre]

You may not need a macro...

Using your posted workbook
• Select from F6 down through the last 10-digit phone number

From the Excel Main Menu:
<data><text-to-columns>
• Check: Fixed width...Click: Next

Insert break points:
• Click between the 3rd and 4th digits from the left
• Click between the 6th and 7th digits from the left
• Click: Next

• Destination: (select cell D6)
• Click: Finish
(When prompted to replace the contents of destination cells...Click: OK)
• Done!

Does that help?

[kcbjordan]

Solved, thanks!

[shg]

Why not just format as phone numbers?

Format > Cells > Number, Special, Phone Number