Please consider supporting this website by buying me a coffee.
Thank you for your consideration!
Updated | November 12, 2024
Extract the Last Word from a Text String
The following formula extracts the last word from the text string in B3...
=TEXTAFTER(B3," ",-1)
For earlier versions of Excel...
=REPLACE(B3,1,FIND("^^",SUBSTITUTE(B3," ","^^",LEN(B3)-LEN(SUBSTITUTE(B3," ","")))),"")
Based on the sample data, the formula returns "Black".
Sample Workbook: Download