H
Hemi
is there a way to remove dashs out of the social security number is excel
spreedsheet
spreedsheet
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
J
Jim May
Using a helper column enter =SUBSTITUTE(A1,"-","") and copy down
Then, Copy this new column to itself using paste-special Values, then
Delete Original SS# with the Dashes
Then, Copy this new column to itself using paste-special Values, then
Delete Original SS# with the Dashes
A
Art
Hemi,
Assume you SS number is in cell A1. Put this in A2:
=SUBSTITUTE(A1,"-","")
This should do it.
Assume you SS number is in cell A1. Put this in A2:
=SUBSTITUTE(A1,"-","")
This should do it.
D
Dave Peterson
Select the range and use
edit|replace
what: - (that dash)
with: (leave blank)
replace all
edit|replace
what: - (that dash)
with: (leave blank)
replace all
J
Jonathan Cooper
I think the other posts have probably answered your question, but it could be
that someone formatted the cells, using the special number format for social
security numbers. In that case, just change the formating.
that someone formatted the cells, using the special number format for social
security numbers. In that case, just change the formating.