@Anonymust, Try this =MAX(IFERROR(MID(A1,1,ROW(INDIRECT("1:"&LEN(A1))))*1,"")) Confirmed with Ctrl-Shift-Enter
=MAX(IFERROR(MID(A1,1,ROW(INDIRECT("1:"&LEN(A1))))*1,""))
There are currently 1 users browsing this thread. (0 members and 1 guests)
View Tag Cloud
Forum Rules
Posting Permissions
Reply With Quote
Bookmarks