removing dashes from phone numbers
 

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?

=SUBSTITUTE(A1,"-","")

HTH
Jason
Atlanta, GA

"Brad" wrote:

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?

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

Then find - and replace with nothing. Click Replace all
--
Gary's Student


"Brad" wrote:

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?

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


"Brad" wrote:

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?