How do I format a social security number to have no dashes?
=LEFT(A1,3)&MID(A1,5,2)&RIGHT(A1,4)
Try this formula if it is all text.
"kim" wrote:
I have a column in Excel with social security numbers and i need to make the
formatting so the number has no dashes in it. So for instance 111-11-1111,
should look like 11111111. Is there a quick way to format my column to look
like this??
Thanks
Kim
|