Hi Razzak,

To search for the last word you can use the formula below.
=RIGHT(A2;LEN(A2)-FIND(" ";A2))

If you have 3 words then you can use this formula.
=LEFT(RIGHT(C45,LEN(C45)-FIND(" ",C45,1)),FIND(" ",RIGHT(C45,LEN(C45)-
FIND(" ",C45,1)),1))
(replace C45 with the cellreference you are using.

Haven't got the formula for the 3 word (or prior to the last word). :(

Good luck,
Tom

On 15 jun, 12:35, Razzak wrote:
Please help me. I would like to separate one word from a cell.

Example : Cell A2 = The Quick Brown Fox

Question-1: How to separate "Fox" from Cell A2?
Question-2: How to separate "Brown" from Cell A2?