| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I remove non-numerical charaters from a string?
I have data formatted like 038-1439-00 and I would like to remove the dashes
so that the cell reads 038143900. Is there a formula in Excel that can strip out the dashes? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I remove non-numerical charaters from a string?
=SUBSTITUTE(A1,"-","")
-- Gary''s Student - gsnu200787 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I remove non-numerical charaters from a string?
Perfect - THANKS!
"Gary''s Student" wrote: =SUBSTITUTE(A1,"-","") -- Gary''s Student - gsnu200787 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I remove non-numerical charaters from a string?
I may be missing something in your question, but if you have the cells
"formatted" to show numbers with dashes, then just change the cell's format to not show them. Rick "Steve" wrote in message ... I have data formatted like 038-1439-00 and I would like to remove the dashes so that the cell reads 038143900. Is there a formula in Excel that can strip out the dashes? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Identify if a cell contains a numerical string | Excel Worksheet Functions | |||
| Counting Charaters | Excel Worksheet Functions | |||
| TRUNCATE SPACE FROM NUMERICAL STRING eg "33Â 033Â 546" | Excel Worksheet Functions | |||
| remove text from string | Excel Worksheet Functions | |||
| remove leading zero from a string.. | Excel Worksheet Functions | |||
Hybrid Mode
