| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Delete characters
I want to be able to remove dashes from a coulmn in
excel..for example in coulmn B i have 3992393-8484-33..and want to just show numbers no dashes..Thanks |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Delete characters
Hi
try =SUBSTITUTE(A1,"-","") and if you want this value as number use: =--SUBSTITUTE(A1,"-","") -----Original Message----- I want to be able to remove dashes from a coulmn in excel..for example in coulmn B i have 3992393-8484- 33..and want to just show numbers no dashes..Thanks . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| delete characters at the end | Excel Discussion (Misc queries) | |||
| delete non numberic characters | Excel Discussion (Misc queries) | |||
| Delete first two characters in a cell... | Excel Worksheet Functions | |||
| Delete first few cell characters | Excel Discussion (Misc queries) | |||
| Delete characters from a string | Excel Programming | |||
Linear Mode
