20
Excel Formulas to Remove the Last Word ~ Easy Tutorial!!
If you have a column of text strings in your worksheet, and you need to remove the first or the last word from the text string in the cell. How could you get them quickly? Excel doesn’t provide a direct way for you, but, with the following formulas, this problem will be solved as soon. Let’s get them below!! Get an official version of ** MS Excel** from the following link: https://www.microsoft.com/en-in/microsoft-365/excel
- Use the below formula to delete the last word from the cell in Excel.
=MID(A1,1,FIND(“~”,SUBSTITUTE(A1,” “,”~”,LEN(A1)-LEN(SUBSTITUTE(A1,” “,””))))-1)
- *SUBSTITUTE * – In Excel, the SUBSTITUTE function replaces existing text with new text in a text string when you want to replace text based on its content, not position.
- LEN – This function will help to return the length of a given text string as the number of characters. Read more on the LEN function.
- MID – The MID function is used to extract the number (starting from the left side) or characters from the given string.
- FIND – This function helps to find out the one text string inside the other. Read more on the FIND function.
- Filename – It represents the input value.
- Comma symbol (,) – It is a separator that helps to separate a list of values.
- Minus Operator (-) – This symbol will help to subtract any two values.
- Parenthesis () – The main purpose of this symbol is to group the elements.
Refer to the below example image.
- First, we will enter the input names in Column B.
- Now we need to delete the last word from these inputs.
- 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 some clarification on how to remove the last word from the text string in Excel. Mention your queries in the comment box below.
Thank you so much for visiting *Geek Excel!! **If you want to learn more helpful formulas, check out Excel Formulas *!! **
20