Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Question from a beginner
I've got a collumn of several hundred phone numbers like the following example.
Number (509) 764-2214 (208) 989-6140 (586) 764-4606 (253) 862-2200 (843) 821-9941 I need to take out the parentheses and hyphens, ideally without having to manually do it. Is there a tool, functionality or process which will take these out for me? Thanks kindly for your time! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Question from a beginner
How about a bunch of Edit|replaces
Select the range Replace ( with (nothing) ) with (nothing) - with nothing and maybe (space character) with nothing (replace all after each) Blaine Davidson wrote: I've got a collumn of several hundred phone numbers like the following example. Number (509) 764-2214 (208) 989-6140 (586) 764-4606 (253) 862-2200 (843) 821-9941 I need to take out the parentheses and hyphens, ideally without having to manually do it. Is there a tool, functionality or process which will take these out for me? Thanks kindly for your time! -- Dave Peterson |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Question from a beginner
Look at EDIT/REPLACE
Find what: ( Hit "Replace All" Repeat for ) and - HTH "Blaine Davidson" wrote: I've got a collumn of several hundred phone numbers like the following example. Number (509) 764-2214 (208) 989-6140 (586) 764-4606 (253) 862-2200 (843) 821-9941 I need to take out the parentheses and hyphens, ideally without having to manually do it. Is there a tool, functionality or process which will take these out for me? Thanks kindly for your time! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Beginner in excel | Excel Discussion (Misc queries) | |||
Excel Beginner, | Excel Worksheet Functions | |||
Beginner Question | Charts and Charting in Excel | |||
Beginner question! | Excel Discussion (Misc queries) | |||
Beginner question | Excel Discussion (Misc queries) |