If space and "-" are the only 2 characters in your string then use this
formula instead in another column and copy it down
=SUBSTITUTE(SUBSTITUTE(A1," ",""),"-","")
Then you can copy and paste special values to eliminate the formulas
"Cheryl B." wrote in message
...
I have an account number of 941 486-1072 041025 in text format.
Need to remove spaces and dashes for a continuous data string.
Tried using find/replace to remove spaces and dashes and it works -
*almost*
The problem is that the last digit of 5 is replaced by a 0 (zero) and
shows
as
9414861072041020
Any suggestions? Other than manually editing each cell, that is?
|