Let’s explore each of these methods to extract first name from full name in Excel <\/span>one-by-one.<\/p>\n <\/p>\n It’s very easy to do Excel extract first name with the LEFT and FIND\u00a0<\/strong>formula<\/a>!<\/strong><\/p>\n Here is the gameplan:<\/p>\n Now, it is essential to understand how these functions work to be able to use them to Excel extract first<\/a> name.<\/p>\n <\/p>\n The FIND Formula<\/a><\/strong> is used to find the position of the specified text<\/strong> within a cell.<\/p>\n The syntax<\/strong> of FIND formula is:<\/p>\n =FIND(find_text, within_text, [start_num])<\/strong><\/em><\/p>\n <\/p>\n The LEFT Formula<\/a><\/strong> is used to extract the specified number of characters from the start<\/strong>\u00a0of a text string.<\/p>\n The syntax<\/strong> of the TEXT formula is:<\/p>\n =LEFT(text, num_chars)<\/strong><\/em><\/p>\n <\/p>\n Moving on, let’s combine these two formulas<\/a> to Excel extract first name from full names.<\/p>\n Follow the step-by-step tutorial below on how to get first name in Excel and<\/a> make sure to download the Excel workbook to follow along:<\/p>\n Download excel workbook<\/i><\/span>Extract-First-Name-From-Full-Name-in-Excel.xlsx<\/span><\/a><\/strong><\/p>\n \n<\/div>\n STEP 1:<\/strong> <\/span>We need to enter the LEFT\u00a0<\/em>function <\/strong>and\u00a0select the Full Name<\/strong>:<\/p>\n <\/p>\n STEP 2:<\/strong><\/span> We need to enter the FIND formula to get the empty space located between the first and last name<\/a><\/strong>:<\/p>\n <\/p>\n STEP 3:<\/strong><\/span> Select the Full Name\u00a0<\/strong>again for the\u00a0FIND formula’s 2nd argument<\/strong>:<\/p>\n <\/p>\n STEP 4:<\/strong><\/span>\u00a0Deduct 1<\/strong> from the\u00a0FIND formula<\/strong> so that our result will return us the text up to the last letter of the first name:<\/p>\n <\/p>\n STEP 5:<\/strong> <\/span>Do the same for the rest of the cells by dragging the formula<\/a> all the way down using the left mouse button.<\/p>\n <\/p>\n Now you are able to\u00a0extract all the\u00a0First Names from your FULL<\/a> NAME using the FIND & LEFT formula in Excel!<\/strong><\/p>\n <\/p>\n A quick and easier way to Excel extract first name<\/a> is to use the Text to Column function!<\/p>\n All you need to know is first the delimiter<\/strong> between the first and last name. Here, the first and last name is separated by a COMMA (,)<\/strong>.<\/p>\n <\/p>\n This function will get the first and last names split into two separate columns. Get this done by following the steps below:<\/p>\n STEP 1:<\/strong> <\/span>Select<\/strong> the cells containing the full names.<\/p>\n STEP 2:<\/strong> <\/span>\u00a0Go to Data<\/strong> > Text to Column<\/strong>.<\/p>\n STEP 3:<\/strong> <\/span>\u00a0In the Convert Text to Columns wizard, Select Delimited<\/strong> Option and Click Next<\/strong>.<\/p>\n A snapshot of your selected data is displayed at the bottom of the wizard.<\/em><\/p>\n STEP 4:<\/strong> <\/span>\u00a0Select one or more delimiter<\/strong> applicable for your data and Click Next<\/strong>. Here, we need to select the delimiter – comma<\/strong>.<\/p>\n If your data contained both comma and space as a separator, you can select both!<\/em><\/p>\n STEP 5:<\/strong> <\/span>\u00a0In this step, you can select the location where you want the output<\/strong> to be displayed. Click on the small arrow<\/strong> next to the destination to insert your destination.<\/p>\n STEP 6:<\/strong> <\/span>\u00a0Select cell D7 <\/strong>and click on the arrow again. STEP 7:<\/strong> <\/span>\u00a0Click Finish<\/strong>.<\/p>\n And, it’s done! The first and last names are now separated and displayed in two separate columns<\/a>.<\/p>\n Further Learning:<\/strong><\/p>\n <\/p>\n","protected":false},"excerpt":{"rendered":" There were countless times when I had a list of full names, and all I needed was the First Name. It would be time-consuming to get the first names one by one. Thank goodness there are formulas for Excel extract the first name from full name to make my life easier! Let’s explore each of […]<\/p>\n","protected":false},"author":2,"featured_media":17312,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"cos_headline_score":0,"cos_seo_score":0,"cos_headline_text":"Excel Extract First Name From Full Name","cos_headline_has_been_analyzed":false,"cos_last_analyzed_headline":[],"om_disable_all_campaigns":false},"categories":[3,483,300,14],"tags":[245,239,246,142,166],"acf":[],"_links":{"self":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts\/6229"}],"collection":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/comments?post=6229"}],"version-history":[{"count":0,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts\/6229\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media\/17312"}],"wp:attachment":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media?parent=6229"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/categories?post=6229"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/tags?post=6229"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}<\/a>Using Find and Left formula<\/strong><\/h3>\n
![\"Excel](\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/04\/Extract-First-Name-From-Last-Name-in-Excel-01.jpg\" "\\"Excel")
<\/a><\/p>\n\n
\n
\n
=LEFT(C7<\/span><\/h2>\n
![\"Excel](\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/04\/Extract-First-Name-From-Last-Name-in-Excel-01B.jpg\" "\\"Excel")
<\/a><\/p>\n=LEFT(C7,\u00a0<\/span>FIND(” “<\/span><\/h2>\n
![\"Excel](\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/04\/Extract-First-Name-From-Last-Name-in-Excel-02.jpg\" "\\"Excel")
<\/a><\/p>\n=LEFT(C7,\u00a0FIND(” “<\/span>, C7)<\/span><\/h2>\n
![\"Excel](\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/04\/Extract-First-Name-From-Last-Name-in-Excel-03.jpg\" "\\"Excel")
<\/a><\/p>\n=LEFT(C7,\u00a0FIND(” “<\/span>, C7)<\/span> -1)<\/span><\/h2>\n
![\"Excel](\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/04\/Extract-First-Name-From-Last-Name-in-Excel-04.jpg\" "\\"Excel")
<\/a><\/p>\n![\"Excel](\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/04\/Extract-First-Name-From-Last-Name-in-Excel-05.jpg\" "\\"Excel")
<\/a><\/p>\n<\/a>Using Text to Column feature<\/strong><\/h3>\n
![\"Excel](\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/05\/Screenshot-492.png\" "\\"Excel")
<\/a><\/p>\n![\"Excel](\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/05\/Screenshot-502.png\" "\\"Excel")
<\/a><\/strong><\/p>\n![\"Excel](\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/05\/Screenshot-489.png\" "\\"Excel")
<\/a><\/p>\n![\"Excel](\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/05\/Screenshot-493.png\" "\\"Excel")
<\/a><\/p>\n![\"Excel](\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/05\/Screenshot-504.png\" "\\"Excel")
<\/a><\/p>\n![\"Excel](\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/05\/Screenshot-496.png\" "\\"Excel")
<\/a><\/p>\n![\"Excel](\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/05\/Screenshot-497.png\" "\\"Excel")
<\/a><\/p>\n![\"Excel](\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/05\/Screenshot-505.png\" "\\"Excel")
<\/a><\/p>\n![\"Excel](\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/05\/Screenshot-500.png\" "\\"Excel")
<\/a><\/p>\n\n