Separating First Name and Last Name using Excel (Hard Way & Easy Way)
I was recently given an Excel worksheet, with the first name and last name separated by a space and had to separate that cell into separate surname and first name cells.
My first solution, because I come from a computing background, involved the LEFT and RIGHT Excel functions. Here are the functions I used:
=LEFT(cell_address,SEARCH(" ",cell_address) -1)
and:
=RIGHT(cell_address,LEN(cell_address) -SEARCH(" ",cell_address))
Only after doing this, did I find a much simpler solution using the 'Text to columns' feature in Excel.
So, to show what I did, and learn from my mistakes, here is a quick video showing the 'hard way' and the 'easy way'.
