Use text processing functions to remove the hyphens in Excel and preserve the actual numbers. Additionally, if your business stores Social Security numbers for any reason, make sure that you're ...

You can split cells into columns in Excel using the "Text to Columns" tool ... This'll usually be a comma, period, dash, or space. 2. Click the "Data" tab and then click "Text to Columns." ...