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.

You can drag the same formula down to remove the hyphens in multiple Social Security numbers. Hover your mouse cursor over the lower-right corner of the cell where you typed the formula.