Table of Contents
To extract the last word from a cell in Google Sheets, you can use the formula =RIGHT(A1,FIND(” “,A1,LEN(A1)-1)-1). This formula will search for the last space in the cell and return the text to the right of that space, which will be the last word in the cell. This method can be useful for organizing data or extracting specific information from a cell in a spreadsheet.
Google Sheets: Extract Last Word from Cell
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:
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.
Cite this article
stats writer (2024). How can I extract the last word from a cell in Google Sheets?. PSYCHOLOGICAL SCALES. Retrieved from https://scales.arabpsychology.com/stats/how-can-i-extract-the-last-word-from-a-cell-in-google-sheets/
stats writer. "How can I extract the last word from a cell in Google Sheets?." PSYCHOLOGICAL SCALES, 26 Jun. 2024, https://scales.arabpsychology.com/stats/how-can-i-extract-the-last-word-from-a-cell-in-google-sheets/.
stats writer. "How can I extract the last word from a cell in Google Sheets?." PSYCHOLOGICAL SCALES, 2024. https://scales.arabpsychology.com/stats/how-can-i-extract-the-last-word-from-a-cell-in-google-sheets/.
stats writer (2024) 'How can I extract the last word from a cell in Google Sheets?', PSYCHOLOGICAL SCALES. Available at: https://scales.arabpsychology.com/stats/how-can-i-extract-the-last-word-from-a-cell-in-google-sheets/.
[1] stats writer, "How can I extract the last word from a cell in Google Sheets?," PSYCHOLOGICAL SCALES, vol. X, no. Y, ص Z-Z, June, 2024.
stats writer. How can I extract the last word from a cell in Google Sheets?. PSYCHOLOGICAL SCALES. 2024;vol(issue):pages.