View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Peo Sjoblom Peo Sjoblom is offline
external usenet poster
 
Posts: 3,268
Default formula for telephone numbers.

doing the same, replace space with nothing, hit space key once in the find
what box and leave replace with empty


--


Regards,


Peo Sjoblom


"biffula" wrote in message
ups.com...
On Nov 2, 1:22 pm, Elkar wrote:
You could use Find/Replace for each of the 3 symbols to eliminate.

Select all of your phone numbers
From the Edit Menu, choose "Replace"
In the Find What field, enter: (
Leave the Replace With field blank
Click "Replace All"
Repeat for ) and - symbols



So simple. It worked. Thanks everyone. NOW, my problem is some of
the numbers had spaces instead of hyphens. Any way to close the
numbers up?

Some now look like this:

123456 7890

Need to look like this:

1234567890