Phone Number Format Changes

rehsas

New Member
Joined
Jan 1, 2009
Messages
1
I have phone numbers entered in the (222) 333-4444 format and need to change them to the 222-333-4444 format. Is there a Find/Replace or other formula that can accomplish this? If so, please provide an example. Thx!
 

Some videos you may like

Excel Facts

Show numbers in thousands?
Use a custom number format of #,##0,K. Each comma after the final 0 will divide the displayed number by another thousand

mole999

Moderator
Joined
Oct 23, 2004
Messages
10,338
Office Version
2019, 2016, 2013
Platform
Windows
I'm sure you can do ") " to "-" find /replace, then "(" to ""

test it one at a time, for the first few then use replace all

speech marks are for emphasis and not required
 

Datsmart

Well-known Member
Joined
Jun 19, 2003
Messages
7,985
This will work for data in Column A:
Code:
Sub Test1()
Dim Rng As Range
Set Rng = Range("A:A")
Rng.Replace What:="(", Replacement:=""
Rng.Replace What:=") ", Replacement:="-"
End Sub
 

Peter_SSs

MrExcel MVP, Moderator
Joined
May 28, 2005
Messages
44,646
Office Version
365
Platform
Windows
I have phone numbers entered in the (222) 333-4444 format and need to change them to the 222-333-4444 format. Is there a Find/Replace or other formula that can accomplish this? If so, please provide an example. Thx!
rehsas

Welcome to the MrExcel board!

You have suggestions for a manual method and a vba method. To round it out, here is a formula method. Formula is copied down.

Excel Workbook
AB
1(222) 333-4444
222-333-4444
2(323) 569-6588323-569-6588
Phone Numbers
 

Watch MrExcel Video

Forum statistics

Threads
1,099,137
Messages
5,466,892
Members
406,507
Latest member
donwiss

This Week's Hot Topics

Top