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'.
En esta página del sitio puede ver el video en línea Separating First Name and Last Name using Excel (Hard Way & Easy Way) de Duración hora minuto segunda en buena calidad , que subió el usuario ShutUpandShowMeHow 03 agosto 2018, comparta el enlace con amigos y conocidos, en youtube este video ya ha sido visto 12 veces y le gustó 0 a los espectadores. Disfruta viendo!
