The Best Office Productivity Tools Kutools for Excel Solves Most of Your Problems, and Increases Your Productivity by If you checked the Split to Rows option in the above Split Cells dialog, every word is extracted from every text string and listed horizontally.Įxtract the nth word from text string in Excel with an amazing tool If you checked the Split to Columns option in the above Split Cells dialog, every word is extracted from every text string and listed vertically. Now specify the destination range that you will output extracted words into, and click the OK button In the opening Split Cells dialog box, specify the split type in the Type section, check the Space option in the Specify a separator section, and click the Ok button. Select the text string cells that you will extract their words from, and click the Kutools > Merge & Split > Split Cells.Ģ. Full feature free trialģ0-day, no credit card required! Free Trial Now!ġ. This method will introduce Kutools for Excel's Split Cells utility to extract each word from text string cells, and then list extracted words horizontally or vertically based on your need.ģ00 handy tools for Excel. Note: In the above formula, A2 is the cell where you want to extract word from, the number 3 indicates the third word in the string that you will extract, and you can change them as you need.Įxtract each word from text string and list them horizontally or vertically Then save the code, in this example, I will get the third word from the string, so type this formula =findword(A2,3) into a blank cell B2, and then drag this cell's AutoFill handle to the range as you need. Function FindWord(Source As String, Position As Integer)ģ. Click Insert > Module, and paste the following code in the Module window. Hold down the ALT + F11 keys to open the Microsoft Visual Basic for Applications window.Ģ. If you want to extract the second, third or any nth word from the text string, you can create a user defined function to deal with it.ġ.

Another word for capture