How to Split Full Name into First Name and Last Name in Excel Using Text to Column

Published: 10 November 2017
on channel: Excel 10 tutorial

485

How to Split Full Name into First Name and Last Name in Excel Using Text to Column Function?

Splitting full name to first name and last name column is crucial. There are several methods to do it.

-----------------------------------------------------------------------------------------------------------
Support Us: / excel10tutorial
-----------------------------------------------------------------------------------------------------------

For example check this tutorial on the same topics: • Split Full Name Into First Name And L...

But this one is the most easiest and efficient version. I will be using “Text to column” function to do it.

Remember I am using Microsoft Excel 2010 for the demonstration. Let’s heed to a step by step tutorial on how to split full name to first name and last name.

Step 1: Select the full name you want to split.

Step 2: Click on “Data” and Click on “Text to column”

Step 3: Click “Next” And check mark on “Space” and uncheck “Tab” And click next

Step 4: Select the destination and click finish

Done. You have success fully split full name into first name and last name in excel using text to column

#excel10tutorial #splitname

Thanks for watching.

If you like this tutorial, please subscribe:
https://goo.gl/uL8fqQ

Checkout our Advance Excel Tutorial Playlist:
https://goo.gl/ExYy7v

Checkout the Excel tutorial for dummies playlist: https://goo.gl/UDrDcA

Checkout the Excel Case playlist:
https://goo.gl/xiP3tv

If you need any specific tutorial you can request that here: https://goo.gl/jM78fA

Connect us on social media

Facebook: https://goo.gl/hdJ7rN

Google Plus: https://goo.gl/Yk4DQc

Watch video How to Split Full Name into First Name and Last Name in Excel Using Text to Column online without registration, duration hours minute second in high quality. This video was added by user Excel 10 tutorial 10 November 2017, don't forget to share it with your friends and acquaintances, it has been viewed on our site 485 once and liked it 7 people.

123