copying only last row data
Posted by jason on December 23, 2001 6:42 PM
I have name information below
MR IAN WILLIAM KERR
MR G A LYMBERY
MRS Sandy lyn Roberts
using text to coloums the data is then seperated and i want to cut the last piece of data (surname)from each row and move it to the front so that when it is imported to access a surname search can be used.
but as the amount of rows differs due to different name lengths this takes forever.
basically cut the last piece of data from each row and past tit to the front.
KERR MR IAN WILLIAM
LYMBERY MR G A LYMBERY
Roberts MRS Sandy lyn