|
|
| Extract
the Last Word from a Text String |
The following formula extracts the last word from the text string in
B2...
=REPLACE(" "&TRIM(B2),1,FIND("^^",SUBSTITUTE("
"&TRIM(B2)," ","^^",LEN(TRIM(B2))-LEN(SUBSTITUTE(TRIM(B2),"
",""))+1)),"")
Based on the sample data, the formula returns "string". Sample
Workbook |
|
|
