ExcelBanter - Social Security Number format

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Social Security Number format (https://www.excelbanter.com/excel-worksheet-functions/16497-social-security-number-format.html)

Jean

Social Security Number format

How do I change social security numbers to leave out the dashes?

PeterAtherton

Jean

With a helper column try =SUBSTITUTE(E6,"-","")

Regards
Peter

"Jean" wrote:

How do I change social security numbers to leave out the dashes?

All times are GMT +1. The time now is 02:33 AM.