How to Extract Last Word from Cell in Google Sheets

In Google Sheets, you can use a combination of functions like RIGHT, LEN, and REPT to extract the last word from a cell. Here's how you can do it:

1. Suppose you have a text string in cell A1, and you want to extract the last word from that cell.
2. In another cell (for example, B1), enter the following formula:

=RIGHT(A1,LEN(A1)-SEARCH("~",SUBSTITUTE(A1," ","~",LEN(A1)-LEN(SUBSTITUTE(A1," ","")))))

This formula will extract the last word from cell A1 and display it in cell B1.

Example

Let's say you have the following text in cell A1: Extract the last word from this text

In cell B1, you can use the formula mentioned above:

=RIGHT(A1,LEN(A1)-SEARCH("~",SUBSTITUTE(A1," ","~",LEN(A1)-LEN(SUBSTITUTE(A1," ","")))))

The result in cell B1 will be text, which is the last word in the text string in cell A1.