How to Split Full Name into First Name, Middle Name and Last Name in Excel

How to Split Full Name into First Name, Middle Name and Last Name in Excel? In the previous video i showed how to split full name to first name and last name. Here is the link: https://youtu.be/Z0uyiPMY-7k Now what if your data has first name, middle name and last name? This is something I need frequently. I run email campaign and splitting names is really important for me. There are numerous other situation where you might need to extract first, middle or last names in excel. 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. ----------------------------------------------------------------------------------------------------------- Support Us: https://www.patreon.com/excel10tutorial ----------------------------------------------------------------------------------------------------------- Step 1: Write the full name in column A Step 2: Write this formula in Column B to extract first Name. Here is the formula for first name: =LEFT(A2,SEARCH(" ",A2)) Step 3: Write this formula in Column C to extract middle Name. Here is the formula for middle Name: =MID(A2,SEARCH(" ",A2,1)+1,SEARCH(" ",A2,SEARCH(" ",A2,1)+1)-SEARCH(" ",A2,1)) Step 4: Write this formula in Column C to extract last Name. Here is the formula for last Name: =RIGHT(A2,LEN(A2)-SEARCH(" ",A2,SEARCH(" ",A2,SEARCH(" ",A2)+1))) Done. You just Split full name to first name column, middle name column and last name column in excel 2010. Hope you like it. #excel10tutorial #splitnames 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