IOU Remove SNN Field For Free

To do this, you can do one of two things:Format the column as Text. Select your data range and press Ctrl+1 to launch the Format > Cells dialog. On the Number tab, click Text.Use the apostrophe character. You can type an apostrophe (') in front of the number, and Excel will treat it as text.

Please do as follows:Select the SSN cells you will remove dashes from, and press Ctrl + H keys together to open the Find and Replace dialog.In the Find and Replace dialog, type dashes into the Find what box, type nothing into the Replace with box, and then click the Replace All button.More items...

Select the data containing the Social Security numbers, then from the Home tab's Editing group, click on Find & Select and select Replace. Enter a hyphen in the Find what text box and leave the Replace with text box blank. Click the Replace All button.

Remove Dashes using Find and ReplaceSelect the dataset from which you want to remove the dashes.Hold the Control key and then press the H key. This will open the Find and Replace dialog box.In the 'Find what' field, type the dash symbol (-)Leave the 'Replace with' field empty.Click on Replace All.

Below are the steps to use find and replace to remove dashes in Excel:Select the dataset from which you want to remove the dashes.Hold the Control key and then press the H key.In the 'Find what' field, type the dash symbol (-)Leave the 'Replace with' field empty.Click on Replace All.

Select the data containing the Social Security numbers, then from the Home tab's Editing group, click on Find & Select and select Replace. Enter a hyphen in the Find what text box and leave the Replace with text box blank. Click the Replace All button.

Avoid ever using a Social Security number again.You may not have removed the number from the system in fact, but you will have removed any use the number may have served the government. The only way to have the government destroy the number and all records connected to it would be to file suit in court.