Posted to microsoft.public.excel.worksheet.functions
|
|
how to remove dashes
One way:
=--SUBSTITUTE(A1,"-","")
the -- will convert the text string into ann actual number. If you want
to leave your "number" as text, omit them.
In article ,
wrote:
I have a list of 500 part number with dashes in between. Example 1234-56-789.
How do able to remove the dashes to make it 123456789?
|