Category Archives: Extracting words

How to extract the first two words in a cell

For example, you have the following the text in a cell “A1″: I want to parse out the first two words in this cell To extract the first two words (“I want”, use one of the following formula: =TRIM(LEFT(SUBSTITUTE(A1,” “,REPT(” “,100)),200)) The result: I want Not working for you? Remember to replace A1 with the […]

Posted in Extracting words | Leave a comment

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 […]

Posted in Extracting words | Leave a comment