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