"Firstname LastName" split this to just "LastName"

[mike91]

Hi there

I have a column with over 2000 entries of name I need to split the column into two so that it shows just the lastname and the other just the firstname

(create to new columns - yes - one called firstname and one called lastname) - copy the contents of the authors to each of the new columns and use this data.

But then how do I extract the lastname?????

 

[KenReay]

Hi

LastName = Mid(FullName,instr(1,Fullname," &quot+1)

but this will only work if all full names have been uniformly created as firstname surname

hope this helps Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
UK