Hyphens in a number stiring in a cell
 

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?

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?

Hyphens in a number stiring in a cell
 

To the right of your data, insert a blank helper column and copy and paste
the following formula in the new column:

=SUBSTITUTE(A2,"-","")

You can then copy the helper column and paste it back to the same location
using PASTE/SPECIAL/VALUES, or use as is.

When no longer necessary, delete the coumn
--
Kevin Backmann


"LLKSmith" wrote:

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?