Parsing words in excel cells

A

Acfonseca

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

Jason Morin

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
 
D

Don Guillett

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Cell data entering slow! 0
Excel --> Word 4
Excel does not accept text format! 0
Merging from an Excel file with graphics 1
Excel - Wich Function should I use? 1
How to open multiple instances of Word 365? 5
Autonumber field in Excel that behaves the same as Access 0
How to make scroll bar permanently visible, Word 365 0

Top