Get the Last Word in Google Sheets Cell or Excel Cell

the-last-word-in-google-sheets

Here’s what you need to retrieve the last word (or the first) 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…

Read Article