Phone Number Format Changes

[rehsas]

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!

 

[mole999]

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]

This will work for data in Column A:

Sub Test1()
Dim Rng As Range
Set Rng = Range("A:A")
Rng.Replace What:="(", Replacement:=""
Rng.Replace What:=") ", Replacement:="-"
End Sub

 

[Peter_SSs]

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
	A	B
1	(222) 333-4444	222-333-4444
2	(323) 569-6588	323-569-6588
Phone Numbers