2] Remove dashes in Excel by using the Find and Replace method This method does not work if a particular format is already applied to your cells, say SSN (Social Security Number) format.

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 ...