formula help
Teethless mama wrote...
=SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(C31,"eq",""),"u p",""),
"down","")+0
....
FTHOI, shorter work-alikes.
=--LEFT(x,MIN(SEARCH({"up","down","eq"},x&"updowneq") )-1)
or
=LOOKUP(1E+307,--SUBSTITUTE(x,{"up","down","eq"},""))
|