Hi, I use to use formula

=MID(C2,MIN(IFERROR(MIN(FIND({0,1,2,3,4,5,6,7,8,9},C2&“0123456789”,1)),LEN(C2)+1)),LOOKUP(1,0*MID(C2,ROW(INDIRECT(“1:”&LEN(C2))),1),ROW(INDIRECT(“1:”&LEN(C2)))) + 1 - MIN(IFERROR(MIN(FIND({0,1,2,3,4,5,6,7,8,9},C2&“0123456789”,1)),LEN(C2)+1)))

Can it be used in EDT or only in excel?

Just wondering

Kim