S
swi
how do I remove the ( ) & - from a list of phone #s (aprx 22K #s)...
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
O
Otto Moehrbach
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
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
E
Elkar
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
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
O
Otto Moehrbach
Elkar obviously meant Edit - Replace. Otto
Richard Buttrey said:EDIT Find Replace?
HTH
Richard Buttrey
__