| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Replace dashes
Hello
I have a column of numbers example 12-2222-02 . I need to delete the dashes. the number should read 12222202 What is the fastest way to do this thanks |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Replace dashes
Use =SUBSTITUTE(A1,"-","")
The last argument is a pair of double quotes with no space between best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "Wanna Learn" wrote in message ... Hello I have a column of numbers example 12-2222-02 . I need to delete the dashes. the number should read 12222202 What is the fastest way to do this thanks |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Replace dashes
=SUBSTITUTE(A1,"-","")
Dave -- Brevity is the soul of wit. "Wanna Learn" wrote: Hello I have a column of numbers example 12-2222-02 . I need to delete the dashes. the number should read 12222202 What is the fastest way to do this thanks |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Replace dashes
Thank soooo much.
"Dave F" wrote: =SUBSTITUTE(A1,"-","") Dave -- Brevity is the soul of wit. "Wanna Learn" wrote: Hello I have a column of numbers example 12-2222-02 . I need to delete the dashes. the number should read 12222202 What is the fastest way to do this thanks |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Replace dashes
Select your range to fix
Edit|replace what: - (dash) with: (leave blank) replace all And maybe applying a custom format after is another way. Wanna Learn wrote: Hello I have a column of numbers example 12-2222-02 . I need to delete the dashes. the number should read 12222202 What is the fastest way to do this thanks -- Dave Peterson |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Replace dashes
Dave Thank you. Also I want to thank you for the click sort module in
Contextures you directed me to the other day. Thank you "Dave Peterson" wrote: Select your range to fix Edit|replace what: - (dash) with: (leave blank) replace all And maybe applying a custom format after is another way. Wanna Learn wrote: Hello I have a column of numbers example 12-2222-02 . I need to delete the dashes. the number should read 12222202 What is the fastest way to do this thanks -- Dave Peterson |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Replace dashes
You're welcome.
That's a good site to bookmark. Wanna Learn wrote: Dave Thank you. Also I want to thank you for the click sort module in Contextures you directed me to the other day. Thank you "Dave Peterson" wrote: Select your range to fix Edit|replace what: - (dash) with: (leave blank) replace all And maybe applying a custom format after is another way. Wanna Learn wrote: Hello I have a column of numbers example 12-2222-02 . I need to delete the dashes. the number should read 12222202 What is the fastest way to do this thanks -- Dave Peterson -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| replace multiple entries in excel state=st west=w east=e conti | Excel Worksheet Functions | |||
| replace multiple entries in excel state=st west=w east=e conti | Excel Worksheet Functions | |||
| replace multiple entries in excel state=st west=w east=e continue | Excel Worksheet Functions | |||
| Lookup and Replace | Excel Worksheet Functions | |||
| Excel: Add replace within selection functionality | Excel Discussion (Misc queries) | |||
Hybrid Mode
