Share via

How can I remove dashes from a social security number?

Anonymous
2014-01-24T14:29:33+00:00

I have a spreadsheet that imported from a personnel system. I need to report some aspects of it to another organization. The SSNs imported with dashes, and I need to report them without dashes. How can I do this relatively quickly?

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

3 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2014-01-24T15:08:52+00:00

    Hi, highlight the whole sheet, press CTRL+H, find enter a dash, replace with don't enter anything, click replace all

    10+ people found this answer helpful.
    0 comments
  2. Anonymous
    2014-01-24T14:39:43+00:00

    Hi,

    Try this for a number in a1. Drag down as required.

    =SUBSTITUTE(A1,"-","")

    10 people found this answer helpful.
    0 comments
  3. Anonymous
    2014-01-24T14:53:21+00:00

    Another option would be to use Edit --> Replace and in the 'Find' box type a dash, leave the "Replace with" box empty and apply/[OK].

    This could affect other entries, so use with caution.

    Also, if your column is narrow, the results may look like scientific notation - just make it wider to show the number 'properly'.

    6 people found this answer helpful.
    0 comments