Paste only last four characters of a string

[jscranton]

I have some folks who need to consolidate information spread across 1000 of spreadsheets into one master sheet. I could write a vba solution for some of the workbooks but they are all in different formats and have different information. Therefore, they are copying and pasting the information into a master sheet. For some of the data, I would like to limit the number of characters that paste (for privacy reasons). Is this possible? To be clear if someone were to copy and paste a column of IDS in this format: 123-45-6789, I only want the 6789 to appear. I do realize I can do this at the end but for various reasons would prefer to do it at the time of the paste action.

Thanks,

Justin

 

[mumps]

I suspect you will need a macro to do what you want.