Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
how do I remove the ( ) & - from a list of phone #s (aprx 22K #s)...
|
#2
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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)... |
#3
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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)... |
#4
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 __ |
#5
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 __ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Stop excel from dropping the 0 in the beginning of a number? | Setting up and Configuration of Excel | |||
Open Excel 2003 from Windows Explorer | Excel Discussion (Misc queries) | |||
Need suggestions for some uses of Ms Excel | Excel Discussion (Misc queries) | |||
Excel Range Value issue (Excel 97 Vs Excel 2003) | Excel Discussion (Misc queries) | |||
Excel 2002 and 2000 co-install. Control Which Starts ? | Excel Discussion (Misc queries) |