I have a spreadsheet which has a column of names eg John Smith, Samuel Saunders etc. I need to split the names over two columns so I end up with a first name column and a last Name column. Can you help me?
Thanks heaps for your answer.
I had some problems getting Cell D1 to work
In the end and thanks to your example, I was able to try a few things out and came up with the following (which works):
Cell A1 insert: John Smith
"Cell B1 insert: =LEFT(A1,SEARCH(" ",A1)-1) *Between the quotes is a space*
*-1 gets rid of the space after the first name*"
Cell C1 insert: =RIGHT(A1,LEN(A1)-SEARCH(" ",A1))