Find Text and Return

[rhmkrmi]

Hi there,

I am trying to find some texts in a column and then return it for lookup.

For example, in cell A1 I have "Please update the spreadsheet".
I need to extract "update the spreadsheet" in cell B1.
I will then use the value in cell in B1 to do a lookup for labeling.

Can you please help me with the formula?

I used SEARCH and COUNTIFS but they only tell me if the specified text exists in the cell or not. They do not return the text that I want to extract.

Note: I have various values in each cell column A and they are in different positions in the cells which means I cannot easily use LEFT, RIGHT, or MID.
There is little uniformity in the data.

Thank you.

 

[rhmkrmi]

I get this error now:

 

[Eric W]

Please show me your formula.

 

[rhmkrmi]

Please show me your formula.

I checked again and noticed that I was updating the formula incorrectly!
It is working like a charm.
Thanks again.

 

[Eric W]

Glad you got it sussed.