pasting a block of stext and formating it in a secial way.

I have a list of numbers seperated by spaces (4995502800509 4994773241769 4969077014388 4969077018706 ect.) I would like a way to paste them into a excel document so that they are on their own individual row and so that only the last 7 numbers are in the cell.

 

Is there any way to do this?

By: Jen

Leave a Reply

Your email address will not be published. Required fields are marked *