Forum Discussion
Extract the text value
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?I have changed the formula for this task slightly. If several hits occur in a text, the first hit from my comparison list is used. In the previous formula, the first match found in the text was used.
=LET(txt,SUBSTITUTE(A1,UNICHAR(10)," "),hli,IFERROR(SEARCH({"0 to";"0 to";"0-";" ?? bar";" ???? bar";" ???? mbar";"? t???? psi";" ???? psi";" ????? psi"},txt),""),sep,XLOOKUP(TRUE,hli<>"",hli),TRIM(MID(txt,sep,1000)))Furthermore, there is no guarantee that all text snippets will be found 100% correctly.