removing dashes from phone numbers

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
In addition to Jason's suggestion, you can also select all the phone #s and
do a Find & Replace, replacing the "-"s with ""s
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Removing Dashes 2
Need to change numbers with dashes to numbers with no dashes 3
Deleting characters that are not numbers 4
Adding a dash to phone numbers 2
Phone Number Excel 2003 7
how do i delete dash in phone numbers 3
Convert a phone number 3
Formatting phone numbers 5

Back
Top