Formula to extract the last word from a cell

  • Thread starter Thread starter Dave K
  • Start date Start date
D

Dave K

Anyone know of a formula that will extract the last word from a cell.

For example if cell contains the text: Best available title

How could I produce the result: "title"

(And preferably be able to fill the formula down the column to get the
last word from other cells in the column as well.)

Thanks for any suggestions.
 
=RIGHT(A1,LEN(A1)-LOOKUP(LEN(A1),FIND("
",A1,ROW(INDEX($A:$A,1,1):INDEX($A:$A,LEN(A1),1)))))
 
Back
Top