38 C
Monday, July 22, 2024

How to Split First Name and Last Name (Splitting the first space) in Excel 2013

Always when there is a CSV import. People won’t give you the right data you need.

and you got to use some excel expertise which will save some time.

I got a list of Contacts with only DisplayName and Email.

But I got to split them with First Name and Last Name

Text to Columns will help, Still some people has two last names. Let me explain both so that you can be clear.

So I got Split the First Column into Firstname and LastName


Choose the Column A (Starters – Click on “A” which will choose the whole Column)

Data –>Text to Columns –>


Choose Space


Now they are separated.


Now what if they have two Last Names and if you use text to columns it will give two Columns for last names.

here is a simple formula to achieve it.



Click on B2 Enter the Formula

=LEFT(A2,FIND(” “,A2)-1)

Click on C2 Enter the Formula

=RIGHT(A2,LEN(A2)-FIND(” “,A2))


Now Click on the Cell and Drag it down.


Now if we have two Last names you can split it with the first space.

Satheshwaran Manoharan
Satheshwaran Manoharanhttps://www.azure365pro.com
Award-winning Technology Leader with a wealth of experience running large teams and diversified industry exposure in cloud computing. From shipping lines to rolling stocks.In-depth expertise in driving cloud adoption strategies and modernizing systems to cloud native. Specialized in Microsoft Cloud, DevOps, and Microsoft 365 Stack and conducted numerous successful projects worldwide. Also, Acting as a Technical Advisor for various start-ups.

Related Articles



Please enter your comment!
Please enter your name here

× How can I help you?