One way. If I understand you, this will find the space and do what you
desire.
=RIGHT(F24,LEN(F24)-FIND(" ",F24)) 2 words
=RIGHT(F24,LEN(F24)-FIND(" ",F24,FIND(" ",F24)+1)) 3 words
--
Don Guillett
SalesAid Software

"Acfonseca" wrote in message
...
I need to move a word from one cell to another, for examle, i have three
words and i want to transfer only the lasts one to another cell. I can't
use
the RIGHT function because it uses a fix number of caracters but this word
can have different leghnts...