How to Extract Last Word from a Cell in Google Sheets

By /

Google Sheets provides a formula to extract the last word from a cell. The formula is “=RIGHT(text, LEN(text) – FIND(” “, text))”. This formula takes the text from the cell, then subtracts the length of the text minus the position of the space from the text which results in the last word of the cell. This is a useful formula to quickly extract the last word from a cell in Google Sheets.

You can use the following syntax to extract the last word from a cell in Google Sheets:

=TRIM(RIGHT(SUBSTITUTE(A2," ",REPT(" ",LEN(A2))),LEN(A2)))

This particular formula will extract the last word from the cell A2.

The following example shows how to use this syntax in practice.

Example: Extract Last Word from Cell in Google Sheets

Suppose we have the following list of phrases in Google Sheets:

We can use the following formula to extract the last word from cell A2:

=TRIM(RIGHT(SUBSTITUTE(A2," ",REPT(" ",LEN(A2))),LEN(A2)))

We’ll type this formula into cell B2 and press Enter:

The formula correctly returns the word fast.

We can then drag and fill this formula down to each remaining cell in column B to extract the last word from each cell in column A:

Google Sheets extract last word from cell

The formula correctly extracts the last word from each cell.

Note that the formula works no matter how long the string or phrase is in any given cell.

Also note that the formula works when the string only contains one word, such as the string in cell A5.

The following tutorials explain how to perform other common operations in Google Sheets:

x

Related terms:

  1. How do I extract the first word from a cell in Google Sheets?
  2. How can I extract the first word from a cell in excel?
  3. How to Extract Last Word from Cell in Excel?
  4. Excel: Extract First Letter of Each Word
  5. Excel: Add a Character Before Each Word in Cell
  6. Excel: Extract Date from Text String How do i extract a date from a text string?
  7. Google Sheets: Extract Text After a Character
  8. How do I use LEFT to extract text before space in Google Sheets?
  9. How to extract a year from a date in Google Sheets?
  10. How to extract numbers from string in Google Sheets?