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.

J. Carlton Collins outlines two ways to remove hyphens from Social Security numbers in Excel.

Borders are lines that form around a cell. In this tutorial, we will explain how to add and remove borders around the cell in Excel.