You can use Excel's built-in substitute function to remove or replace a substring of a string of characters in Excel. This can include removing hyphens from Social Security numbers or any other ...

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.

Q: I have an Excel worksheet containing hundreds of Social Security numbers, and I want to remove the hyphens. Can you tell me how this can be done? A: I can think of two ways to remove hyphens from ...