Thread: Parsing words in excel cells

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

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

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
donaldb@281.com
"Acfonseca" <Acfonseca@discussions.microsoft.com> wrote in message
news:3BC6B195-7D2E-4F6B-B040-E5C9B5EB2147@microsoft.com...
> 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...