I would like to know if there is a way to remove hyphens in a column
containing social security numbers without retyping all of the numbers over.

Thanks!

Select the range (whole column???) and do
Edit|Replace
what: - (Hyphen)
with: (leave blank)
replace all.

Laurie wrote:

I would like to know if there is a way to remove hyphens in a column
containing social security numbers without retyping all of the numbers over.

Thanks!

--

Dave Peterson

That may not work if the cell is formatted as
Category: Special
Type: Social Security Number

If it's formatted that way, you can probably just remove them by changing to
format to NUMBER (if you really want it that way).

"Dave Peterson" wrote:

Select the range (whole column???) and do
Edit|Replace
what: - (Hyphen)
with: (leave blank)
replace all.

Laurie wrote:

I would like to know if there is a way to remove hyphens in a column
containing social security numbers without retyping all of the numbers over.

Thanks!

--

Dave Peterson