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.

How to Remove Dashes From Social Security Numbers in Excel. A Social Security number consists of three strings of digits separated by hyphens. The first is an area number, which relates to the ...

A: I can think of two ways to remove hyphens from Social Security numbers in Excel. Find and Replace method. Select the data containing the Social Security numbers, then from the Home tab’s Editing ...

To clear formatting from the selected cells in your workbook in Microsoft Excel, you can use Clear Formats, Keyboard shortcuts, Format Painter tool, etc.