PaddyD said:=MCONCAT(IF(--(MID(A2,{1,2,3},1))<5,"L","H"))
Aladin Akyurek said:PaddyD said:=MCONCAT(IF(--(MID(A2,{1,2,3},1))<5,"L","H"))
The latest version introduces the so-called REGEX functions:
=REGEX.SUBSTITUTE(REGEX.SUBSTITUTE(A2,"0|1|2|3|4","L"),"5|6|7|8|9","H")
CARBOB:
Why don't you invoke in D2:
=SUM((MID(A2,{1,2,3},1)+0))