Here’s what you need to retrieve the last word in Google Sheets cells or using Excel if that’s your preference.

Get the Last Word in Google Sheets

=TRIM( RIGHT( SUBSTITUTE( A1 ; " " ; REPT( " " ; 100 ) ) ; 100 ) )

but if you might have any trailing spaces in your cell use this to get the last word.

=TRIM( RIGHT( SUBSTITUTE( TRIM( A1 ) ; " " ; REPT( " " ; 100 ) ) ; 100 ) )

To use it, put the the phrase you want to parse for the last work in cell A1 and the function above in cell B1 and hit enter.  Or put a whole column of phrases into the A column, setup the function in the B column and drag it down from the bottom right corner.

Get Last Word in Google Sheets Column

Drag down and you have your last word  from the phrase parsed into column B.

get-last-word-in-google-sheets-for-column-of-phrases2

Parse last word in Excel cell

This works to parse the last word in excel

=MID(SUBSTITUTE(A1," ","^",LEN(A1)-LEN(SUBSTITUTE(A1," ",""))),FIND("^",SUBSTITUTE(A1," ","^",LEN(A1)-LEN(SUBSTITUTE(A1," ",""))))+1,256)

Example:

parse last word in excel cell

Source:http://howtouseexcel.net/how-to-extract-the-last-word-in-a-cell-in-excel