removing dashes from phone numbers

B

Brad

i have a column of phones numbers with the format 555-111-2222 and I want to
remove the dashes so that they are 5551112222 so that I can use a vertical
lookup. What's the easiest way to do this?
 
G

Gary's Student

You can use Edit Find to open the find/replace window.

Then find - and replace with nothing. Click Replace all
 
D

Duke Carey

In addition to Jason's suggestion, you can also select all the phone #s and
do a Find & Replace, replacing the "-"s with ""s
 
Top