How to extract the first word in a cell in Excel

Looking to parse out or extract the first word from a string of words in Excel? The example below show two formula or functions that we can use to do this.

For example, you have the following the text in a cell “A1”:

An MBA from Harvard Business School is priceless

To extract the first word “My”, use one of the following formula:

=LEFT(A1,FIND(" ",A1)-1)

or

=IF(ISERR(FIND(" ",A1)),A1,LEFT(A1,FIND(" ",A1)-1))

The result:

An

This entry was posted in Extracting words. Bookmark the permalink. Post a comment or leave a trackback: Trackback URL.

Post a Comment

Your email is never published nor shared. Required fields are marked *

You may use these HTML tags and attributes <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>

*
*