Help with Excel
 

how do I remove the ( ) & - from a list of phone #s (aprx 22K #s)...

Help with Excel
 

Do Edit - Replace. In Find what, put "(". In the Replace it with space put
nothing at all. Click Replace All.
Do that with the ")" and the "_" as well.
If you end up with a space where you don't want it, do it again. This time
in Find What, put " ". Note that the quotes have a space between them.
Replace that with nothing at all. HTH Otto
"swi" wrote in message
...
how do I remove the ( ) & - from a list of phone #s (aprx 22K #s)...

Help with Excel
 

You can use a FIND/REPLACE.

Highlight your range of phone numbers
Select "Replace..." from the Edit Menu.
In the "Find what" field, enter the first symbol (
In the "Replace with" field, leave it blank
Click "Replace All"
Repeat for the other two symbols

HTH,
Elkar



"swi" wrote:

how do I remove the ( ) & - from a list of phone #s (aprx 22K #s)...

Help with Excel
 

On Fri, 10 Mar 2006 13:20:26 -0800, swi
wrote:

how do I remove the ( ) & - from a list of phone #s (aprx 22K #s)...

EDIT Find Replace?

HTH
Richard Buttrey
__

Help with Excel
 

Elkar obviously meant Edit - Replace. Otto
"Richard Buttrey" wrote in
message ...
On Fri, 10 Mar 2006 13:20:26 -0800, swi
wrote:

how do I remove the ( ) & - from a list of phone #s (aprx 22K #s)...

EDIT Find Replace?

HTH
Richard Buttrey
__