Replacing last 3 characters and adding them to front
Hi,
I had a question I was wondering if anyone could help me with.
I had an excel file with a bunch of numbers... Variable lengths. All
the numbers are in a single column. At the end of the numbers are
always 3 letters. Is there a way to delete those three letters off each
of these numbers and put them at the front of the number instead of at
the end?
For example...
111222457YAA should be converted to YAA111222457
Thanks for any help!!
|