Hi

I am trying to transfer names from one excel spreadsheet in this format, in one column I have the full name "mr john smith" - I need to transfer the 1st name and 2nd name individually so it sits in my new spreadsheet in 2 x columns 1st name - John and 2nd name Smith. I am hoping there is a better, quicker way of doing it rather than me manually splitting and copying each name - I have 900 accounts to go through-- please help, thanks Jacqui