So, you have a big list of contacts but one column has both, first and last name, but you need them separately, because you want to upload it to a CRM system or somewhere else. This example shows the name being formatted in this way: “John Doe”. The formulas will extract the left name and place it into a First Name column and the last name into a different column.
First Name column would look like this: =LEFT(A1,FIND(“,”,A1)-1)
Last Name column would look like this: =RIGHT(A1,LEN(A1)-FIND(” “,A1))
After that, just select all the cells down and hit CTRL + D.
Reference: http://www.ozgrid.com/forum/showthread.php?t=64545&page=1
