Hi Pii
Assume SS Numbers In Column A
In Column B =Left(A1,3)
In Column C =Mid(A1,5,3)
In Column D =Right(A1,4)
In Column E =B1&C1&D1
Copy down all formulae in Columns B,C,D & E
Then CopyPasteSpecial Values Of Column E Into Column F And Delete Columns B to E
Mathew
"Pii via OfficeKB.com" wrote in message ...
I have a bunch of social security numbers for employees in the following
format. We are exporting this report to the tax office and they do not
accept hyphens in the ss numbers. We have over 1000 numbers and I don't
want to do it by hand. Thanks in advance
123-456-7890
Need it to look like
1234567890
|