Trim all but the last four digits off a list of SSN's.

R

rhodesmk

I have a list of SSN's, but only want the last four digits to show. Is there
a way to quickly knock those first five digits out of the picture?

Thanks.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How can I sort a list of numbers by the last 4 digits? 2
How do I compare the stored data in micro 3
leading zeros are not showing in the formula bar but do show in ce 2
how do i show only the last four digits of a credit card number 5
How do I enter a SSN but only display the last four digits? 1
Copy and Paste Help 2
filter query 1
Import data 1

Top