38 C
Dubai
Monday, August 8, 2022
spot_img

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

image

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

Data –>Text to Columns –>

image

Choose Space

image

Now they are separated.

image

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.

image

Now

Click on B2 Enter the Formula

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

Click on C2 Enter the Formula

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

image

Now Click on the Cell and Drag it down.

image

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

Satheshwaran Manoharan
Satheshwaran Manoharanhttps://www.azure365pro.com
Specialized in Microsoft Azure - Office 365 / Microsoft Exchange; conducted numerous projects worldwide in designing, supporting, and implementing messaging and virtualization infrastructure for medium-sized and large enterprises. Further, I am a Cloud Architect and Technical Advisor for various start-ups.

Related Articles

1 COMMENT

LEAVE A REPLY

Please enter your comment!
Please enter your name here