Learn how to display only the last 4 digits of a credit card, SSN and/or phone number in Excel..
Let's imagine you want to display only the last four digits of a credit card number, identification number, Social Security number, or other information and hide the remaining digits with asterisks for standard security measures. In this video, I will demonstrate how to do that. You can use the same method regardless of whether the digits in your cell are written as text, numbers, or the unique Social Security number format.
Here is the formula.
="************"&RIGHT(A2,4)
show only last 4 digits excel,show only last 4 digits of social security number in excel,how to unmask numbers in excel,last 4 digits of ssn lookup free,formula to mask numbers in excel,last 4 digits of ssn on credit card,last 4 digits of ssn and dob,
show only last 4 digits excel,how to unmask numbers in excel,last 4 digits of ssn lookup free,formula to mask numbers in excel,last 4 digits of ssn on credit card,
display only last few digits of a SSN number,display last 4 digits of a credit card number,show last few digits of student ID
