Hyphens in a number stiring in a cell
select the range, click on Edit Menu and on replace
replace "-" (no quotes) to ""
hth
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo
"LLKSmith" escreveu:
I have a long column of numbers and I want to see them in a set 13-digit
string, no hyphens. The column I have - some numbers have hyphens, some
don't; all are randomly placed. Is there a way to edit out the hyphens
quickly, without losing the data?
|