For example, you have the following the text in a cell “A1″:
I want to remove the last word in a cell in this cell
To remove the last word in cell “A1″, use one of the following formula:
=IF(ISNUMBER(SEARCH(" ",TRIM(A1))),TRIM(SUBSTITUTE(A1,TRIM(RIGHT(SUBSTITUTE(TRIM(A1)," ",REPT(" ",99)),99)),"")),A1)
I want to remove the last word in a cell in this
Not working for you?
Remember to replace A1 with the cell that contains the string of words you want to parse out.