Split Full Name Into First Name And Last Name In Excel

Split Full Name Into First Name And Last Name In Excel

This is something I need frequently. I run email campaign and splitting names is really important for me. I thought why not make a tutorial for it.

This is actually splitting text into column. I will be using excel formula to split names and I am using Microsoft excel 2010 for the demonstration. Let’s get started.

-----------------------------------------------------------------------------------------------------------
-----------------------------------------------------------------------------------------------------------

Step 1: Write the full name in column A

Step 2: Write this formula in Column B to get First Name. Here is the formula for first name:
=LEFT(A2,FIND(" ",A2,1)-1)

Step 3: Write this formula in Column C to get Last Name. Here is the formula for Last Name:
=RIGHT(A2,LEN(A2)-FIND(" ",A2,1))

Done. You just Split full name to first name column and last name column in excel 2010. Hope you like it.

Thanks for watching.

#excel10tutorial #splitnames

If you like this tutorial, please subscribe:

Checkout our Advance Excel Tutorial Playlist:

Checkout the Excel Case playlist:

Connect us on social media

[salomiratnagrahi]

Thank you very much! It worked, quick and easy :)

[forchuclerance]

Thank yo u so much. I was meant to do this manually and was wondering if there was a possibility to use a formula, then i stumbled on your tutorial. God bless you.

[selemanemmanuellubis]

Make a video on how to create the formula