VBA to Grab Right 4 Characters of Array of Cells and Paste to Same Array

I have some SSNs that I need to truncate to the last four numbers so I'm not sending full SSNs around.

Say I have this four-cell array:
000-00-0000 987-65-4321
123-45-6789 010-10-1010

I want to copy and paste so it looks like:
0000 4321
6789 1010

How would I go about doing this? I know how to do it using a helper column with a RIGHT formula and then pasting over as values then deleting the helper column but I'm sure there is a better way to simply remove those left seven characters, right?

Thanks.

No loop required.

Please Login or Register  to view this content.

Thanks all, thread marked as Solved.