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'.
On this page of the site you can watch the video online Separating First Name and Last Name using Excel (Hard Way & Easy Way) with a duration of hours minute second in good quality, which was uploaded by the user ShutUpandShowMeHow 03 August 2018, share the link with friends and acquaintances, this video has already been watched 12 times on youtube and it was liked by 0 viewers. Enjoy your viewing!
