Search text in Cell and return value from another cell

[goranimo]

Hi,

I don't know if this should be posted in VBA, because I don't know what would be the best solution for my problem.

It's kind of difficult to explain my problem, so I've attached a sample.

Any idea?

[Glenn Kennedy]

what is the maximum number of "words" in column A? In your real data, are there any features of the desired string that would enable them to be extrcted from the text?

Basically, I'd like to see some real data that is REPRESETATIVE of what you are dealing with, to look for patterns that could help.

[goranimo]

I can extract the text from cells so that there will be only 1 fruit in column A and only one fruit in column B if that helps.

It's kind of confidential data, I can't post in in a forum.

[MickG]

Try:-

Please Login or Register  to view this content.

Regards Mick

[Glenn Kennedy]

So, post an exampole of what you mean. I'm not going to spend time on something I haven't seen, in case I go wrong at step 1.

[goranimo]

Thank you MickG! Worked perfectly.

[MickG]

You're welcome