Forum Discussion

ajmal_pottekattil_yoousuf's avatar
ajmal_pottekattil_yoousuf
Iron Contributor
Jun 13, 2024
Solved

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...
excel
Formulas and Functions
dscheikey's avatar
dscheikey
Bronze Contributor
Jun 16, 2024

ajmal_pottekattil_yoousuf 

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.

Resources