Need to remove hypens from typed in telephones (not formatted)!!

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

Guest

Rows of typed in phone numbers with hyphens...not formatted cells...how do I
remove the hyphens ONLY?!?!

Please I need an answer FAST!
 
Hi

Try using Find/Replace (Ctrl H). That should do the job for you.

Andy.
 
You must log in or register to reply here.

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 hypen from existing text 2
Remove data that preceeds a character 6
Format cell so number entered will show only one way 2
How to write Left Function in VB 2
Ignore "-" 6
combining =SEARCH & =IF statements 4
Removing text between hyphens and removing the hyphens 8
Extracting (Copying) Text to the Right of a Hyphen 3

Back
Top