for the SSNs -- use this example for SSN in cell A1:

=LEFT(A1,3)&MID(A1,5,2)&RIGHT(A1,4)

Phone numbers would depend on the exact format.


--
hope to help,
cm


"cheryltraining" wrote:

The spreadsheet we're working has social security numbers and phone numbers
with dashes included. Need to remove dashes and not lose the leading zero in
the SSN.