Forum Discussion
Extract the text value
Exacting the range and readability from the instrument type How to extract it please guide me i filter the data( please refer the other sheet) and try to extract. In this method is correct or no...
I've looked at your tables and unfortunately I can't understand what you're trying to achieve. Since no one else has answered your questions, I assume that I was not the only one who felt this way.
Please describe exactly what result you expect in which cell in which sheet. Then you will certainly be able to answer well-formulated, complete questions in full sentences.
I am trying to extract the range and readability from the text.
Could you please refer to this Excel sheet?
In this mode, we want to split every data.
I suppose that could help you. No guarantee of 100% hits.
=SUBSTITUTE(A2,UNICHAR(10)," ")=TRIM(MID(SUBSTITUTE(A2,UNICHAR(10)," "),MIN(IFERROR(SEARCH({" ?? hr";" ?? h ";" ? hr";" ? h ";" ??? min";" ?? min"},SUBSTITUTE(A2,UNICHAR(10)," ")),"")),1000))Now I am trying another instrument Pressure Gauge.
I have been facing some issues.
I highlighted it in red colour.
Could you please help me to solve this issue?
- You can use textsplit textafter or textbefore formulas. Since I can't understand your data logic and from where your data requirement starts and end I can't give you exact formula
