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

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.

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

=RIGHT(A1,4)
--
Gary''s Student - gsnu200816

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

Perfect!

Thanks,

Michael

"Gary''s Student" wrote:

=RIGHT(A1,4)
--
Gary''s Student - gsnu200816