One way:

=RIGHT(A1,MATCH(" ",MID(A1,1+LEN(A1)-ROW(INDIRECT("1:"&LEN
(A1))),1),0)-1)

Press ctrl/shift/enter after inserting this formula. It's
an array formula.

HTH
Jason
Atlanta, GA

-----Original 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...
.