Working with large lists of data

Hi Andrew, thanks for your query. The following link will show you how to chop the name up, but you'll still need to concatenate the title and surname to get what you want:

http://www.exceltip.com/st/Extract_the_first ,_middle_and_last_name_in_Microsoft_Excel/370.html

Hope this helps,

Anthony