Excel Formula
Budget: $10 – $30 USD
I need a formula that can search an entire spread sheet, locate partial text in a text string, and then return only the remaining text in that string.
For example (and you can use the example in the formula)
Text string in random cell = "Information Sharing No I do not wish to share my information"
Formula in cell XY searches sheet for "Information Sharing"
Returns only the remaining text "No I do not wish to share my information" as the value in cell XY.
The data that I will be dropping into the sheet to sort, comes in random order. I basically need this formula so that I can quickly reorder it for documentation.
For example (and you can use the example in the formula)
Text string in random cell = "Information Sharing No I do not wish to share my information"
Formula in cell XY searches sheet for "Information Sharing"
Returns only the remaining text "No I do not wish to share my information" as the value in cell XY.
The data that I will be dropping into the sheet to sort, comes in random order. I basically need this formula so that I can quickly reorder it for documentation.