17.9 C
London
Thursday, July 24, 2025
HomeSoftware TutorialsGoogle SheetsGoogle Sheets: How to Extract Last Word from Cell

Google Sheets: How to Extract Last Word from Cell

Related stories

Learn About Opening an Automobile Repair Shop in India

Starting a car repair shop is quite a good...

Unlocking the Power: Embracing the Benefits of Tax-Free Investing

  Unlocking the Power: Embracing the Benefits of Tax-Free Investing For...

Income Splitting in Canada for 2023

  Income Splitting in Canada for 2023 The federal government’s expanded...

Can I Deduct Home Office Expenses on my Tax Return 2023?

Can I Deduct Home Office Expenses on my Tax...

Canadian Tax – Personal Tax Deadline 2022

  Canadian Tax – Personal Tax Deadline 2022 Resources and Tools...

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.

Additional Resources

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

Google Sheets: How to COUNTIF Not Equal to Text
Google Sheets: Filter for Cells that Do Not Contain Text
Google Sheets: How to Reverse a Text String

Subscribe

- Never miss a story with notifications

- Gain full access to our premium content

- Browse free from up to 5 devices at once

Latest stories