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