L
Leslie
What is the formula to remove the dashes from social
security numbers?
security numbers?
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.
C
Chip Pearson
Leslie,
Try something like
=SUBSTITUTE(A1,"-","")
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com [email protected]
Try something like
=SUBSTITUTE(A1,"-","")
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com [email protected]
T
Thomas
Select the range of SS nubers and do a Edit >replace - with nothing.
D
Dave Peterson
And if the dashes are inserted because the number is formatted as
Format|Cells|Number tab|Special category|SSN, just format the cell as General.
Format|Cells|Number tab|Special category|SSN, just format the cell as General.
E
EZ Money
Edit>Find and Replace>->Replace With>*leave blank*>Replace All>OK