Jun 29, 2015
Using MID, SEARCH, LEN formulas to extract information from a combined text – Microsoft Excel Tips
Using MID, SEARCH, LEN formulas to extract information from a combined text – Microsoft Excel Tips
In this post we are explaining how to use the text functions like MID, SEARCH and LEN. To understand these functions clearly we are taking a scenario.
Our scenario is to extract the required information from a combined text format. Please find below the screenshot to understand the combined text format.
Combined Text Format Required Result 1:
Use the formula to extract only the question Requir…
View On WordPress