Hi Masters.
"In this text string which text has maximum length"
Answer is maximum
I have built a formula which works good but it is too biggi...
B2=INDEX(INDEX(TRIM(MID(SUBSTITUTE(A1," ",REPT(" ",LEN(A1))),((ROW(INDIRECT("1:"&LEN(A1)-LEN(SUBSTITUTE(A1," ",""))+1)))-1)*LEN(A1)+1,LEN(A1))),),MATCH(MAX(INDEX(LEN(INDEX(TRIM(MID(SUBSTITUTE(A1," ",REPT(" ",LEN(A1))),((ROW(INDIRECT("1:"&LEN(A1)-LEN(SUBSTITUTE(A1," ",""))+1)))-1)*LEN(A1)+1,LEN(A1))),)),)),INDEX(LEN(INDEX(TRIM(MID(SUBSTITUTE(A1," ",REPT(" ",LEN(A1))),((ROW(INDIRECT("1:"&LEN(A1)-LEN(SUBSTITUTE(A1," ",""))+1)))-1)*LEN(A1)+1,LEN(A1))),)),),0))
Any alternative will be great and it should also non array
Bookmarks