Dear all,

I recently imported some data in excel from a .csv file only to find thta
column O (containing last names) has been corrupted somehow. some last
names are mixed up with the last 1 or 2 character of the middle name
e.g S.Simon should really be simon. I would like to get a macro which will
loop through column O and remove anything before a period. In some cases
column may have 2 periods e.g M.G.Taylor when I only want Taylor. The macro
should remove everything before Taylor

Please assist

Many thanks