To separate the first and the last name from a cell in Microsoft Excel, you can use a combination of a few functions. Use the “Left” function combined with “Search” function for picking the first name and forthe last name use the “Right” function combined with “Len” function and “Search” function.
To separating names follow below steps in Excel:-
Example : We have a list of names in Column “A” and we need to pick the First name from the list. We write the “LEFT” function along with the “SEARCH” function.
- Select the Cell B2, write the formula =LEFT (A2, SEARCH (” “, A2)), function will return the first name from the cell A2
- To copy the formula in all cells press the key “CTRL + C” and select the cell B3 to B6 and press the key “CTRL + V”
To pick the Last name from the list, we need to use the “RIGHT” function along with “SEARCH” function and “LEN” function
- Select the Cell D2, write the formula =RIGHT(A2,LEN(A2)-SEARCH(” “,A2,SEARCH(” “,A2,SEARCH(” “,A2)+1))) function will return the last name from the cell A2
- To copy the formula in all cells press the key “CTRL + C” and select the cell D3 to D6 and press the key “CTRL + V”
If you liked our blogs, share it with your friends on Facebook. And also you can follow us on Twitter and Facebook.
We would love to hear from you, do let us know how we can improve, complement or innovate our work and make it better for you. Write us at firstname.lastname@example.org