LinkBack URL
About LinkBacks
I Have 1000+ SSN on a spreadsheet exported from payroll system
I need to trim them down to the last 4 digits of each SSN
I'm using =RIGHT(A1,4)
How do I do this for ALL rows?
I tried =RIGHT(A1:A1000,4) but that doesn't work.
Any advice?
I Have 1000+ SSN on a spreadsheet exported from payroll system
I need to trim them down to the last 4 digits of each SSN
I'm using =RIGHT(A1,4)
How do I do this for ALL rows?
I tried =RIGHT(A1:A1000,4) but that doesn't work.
Any advice?
Just put the formula in one cell and then copy it down.
i.e.
RIGHT(A1,4)
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
I didn't think of that. Thanks so much.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks