26
Excel Formulas to Get the Last Word of a Text String ~ Quick Method!!
In the previous post, we have learned the formula to find the first word of the text string in Excel. Likewise, here we will see the formulas to get the last word of a text string in Excel. Let’s dive into this article!! Get an official version of ** MS Excel** from the following link: https://www.microsoft.com/en-in/microsoft-365/excel
- If you want to find the last word of the text string, you can use the below formula.
*=TRIM(RIGHT(SUBSTITUTE(text,” “,REPT(” “,100)),100)) *
- TRIM – This function removes the extra spaces from the text and there is no space at the start or end of the text string. Read more on the TRIM function.
- RIGHT – In Excel, the RIGHT function helps to extract the texts with the given number of characters from the right side.
- SUBSTITUTE – This function helps to replace existing text with new text in a text string when you want to replace text based on its content, not position. Read more on the SUBSTITUTE function.
- REPT – The REPT function will help to repeat characters a given number of times.
- Minus Operator (-) – This symbol will help to subtract any two values.
- Text – It represents the input value.
- Comma symbol (,) – It is a separator that helps to separate a list of values.
- Parenthesis () – The main purpose of this symbol is to group the elements.
Let’s consider the below example image.
- First, we will enter the input text strings in Column B.
- Here we need to extract the last word.
- Select any cell and type the above-given formula.
- Finally, press the ** ENTER** key, you can get the result as shown below.
From this guide, you can get to know the formulas to get the last word of a text in Excel. Hope you like it. If you have any questions or suggestions regarding this lesson, feel free to use the comments section below to let us know.
Thank you so much for visiting *Geek Excel!! **If you want to learn more helpful formulas, check out Excel Formulas *!! **
26