Snasui Excel Forum

Hi there


I need your help how to extract text from cell containing Widget.

I attach a template as well

Thanks

In C2 enter this formula,

=FILTERXML("<k><m>"&SUBSTITUTE(SUBSTITUTE(A2,"_"," ")," ","</m><m>")&"</m></k>","//m[contains(.,'Widge')]")

or

=TRIM(LEFT(SUBSTITUTE(MID(A4,AGGREGATE(15,6,SEARCH({"Econo","Ultra","Thermo","|"},A4&"|"),1),20)," ",REPT(" ",20)),20))

Enter and copy down.

Thank you so much

I got a problem bec the results not like the color cells in next column

Thanks

...

B2

=IFERROR(INDEX({"WELVU","ECONO","ULTRA","BC","DENDR","THERMO"},MATCH(TRUE,SEARCH({"WELVU","ECONO","ULTRA","BC","DENDR","THERMO"},A2)>0,0)),"")

Norkaz

Thanks