LSAT Insert SNN Field For Free

What is a truncated Social Security number (SSN)? A truncated SSN is the last four digits of an SSN. It is considered sensitive Personally Identifiable Information (PII), both stand-alone and when associated with any other identifiable information.

Sensitive personally identifiable information can include your full name, Social Security Number, driver's license, financial information, and medical records. Non-sensitive personally identifiable information is easily accessible from public sources and can include your zip code, race, gender, and date of birth.

As you know, an SSN is made by 9 digits with two dashes. And two dashes are fixed in fourth place and seventh place.

And in the Format Cells dialog box, under the Number tab, click Special from the Category pane, and then click Social Security Number under the Type list box. 4. Then click OK to close this dialog, and your numbers have been added the dashes in the original cell range at once.

The SSN must be nine (9) numerical characters only. Spaces, alphabetic characters, hyphens, slashes or any other special characters are not allowed.

=LEFT(A1, LEN(A1)-4). Paste the formula in the cell, and the last four digits will be removed from your data. This formula can also be used to trim the last letters from text. I hope you understood this tutorial.

The last 4 digits of an SSN are important because if they're in the wrong hands, they might lead to identity theft and you might get in trouble due to someone else's actions.Never give them to any person who calls you or emails you requesting too many details regarding your SSN.