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?