Try this formula
=IFERROR(AGGREGATE(14,6,MID(A1,ROW(INDIRECT("1:"&LEN(A1))),{6,7})+0,1),"No number")
Try this formula
=IFERROR(AGGREGATE(14,6,MID(A1,ROW(INDIRECT("1:"&LEN(A1))),{6,7})+0,1),"No number")
Audere est facere
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks