| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
omitting/deleting "-"'s from numbers w/ formula
I have a group of numbers that look like this ###-##-####g09. I have been
able to omit the "g09" at the end but i need the "-"'s omitted as well. Can this be done with a formula or do i just need to use find/replace? Thanks -- Eric |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
omitting/deleting "-"'s from numbers w/ formula
=SUBSTITUTE(LEFT(A1,11),"-","")
so 123-45-6789g09 will output 123456789 -- Gary''s Student - gsnu200826 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
omitting/deleting "-"'s from numbers w/ formula
Thanks Gary, that works great!
-- Eric "Gary''s Student" wrote: =SUBSTITUTE(LEFT(A1,11),"-","") so 123-45-6789g09 will output 123456789 -- Gary''s Student - gsnu200826 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| deleting or omitting "-"'s in a group of numbers w/ a formula | Excel Discussion (Misc queries) | |||
| Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
| any formula to convert numbers in word form, e.g. "2" as "Two"? | Excel Worksheet Functions | |||
| Validation ?:Accepting both Numbers AND specific letters("N","n"," | Excel Discussion (Misc queries) | |||
| Deleting the "'" character in the text formula | Excel Discussion (Misc queries) | |||
Hybrid Mode
