Or this array formulaFormula:
=MID(A1,1,MATCH(TRUE,ISERROR(1*MID(A1,ROW(INDIRECT("1:25")),1)),0)-1)*1
This being said, the solution for this type of problem is all over the Net...
Or this array formulaFormula:
=MID(A1,1,MATCH(TRUE,ISERROR(1*MID(A1,ROW(INDIRECT("1:25")),1)),0)-1)*1
This being said, the solution for this type of problem is all over the Net...
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks