{"text_format":"3","workbook":"xlsx","n_sheets":6,"sheets":["XLOOKUP","INDEX-MATCH","VBA","MATCH+CODE","MID+ FIND","MIN + FIND"],"read":"whole","date_system":"1900"}

{"sheet":"XLOOKUP","index":0,"n_rows":11,"n_cols":2,"rows_kept":11}
["Text Data","First Number"]
["AB23X9",{"$f":"IFERROR(XLOOKUP(TRUE,ISNUMBER(--MID(A2,SEQUENCE(LEN(A2)),1)),MID(A2,SEQUENCE(LEN(A2)),1),\"\"),\"\")","v":""}]
["77Test",{"$f":"IFERROR(XLOOKUP(TRUE,ISNUMBER(--MID(A3,SEQUENCE(LEN(A3)),1)),MID(A3,SEQUENCE(LEN(A3)),1),\"\"),\"\")","v":""}]
["Code9XYZ",{"$f":"IFERROR(XLOOKUP(TRUE,ISNUMBER(--MID(A4,SEQUENCE(LEN(A4)),1)),MID(A4,SEQUENCE(LEN(A4)),1),\"\"),\"\")","v":""}]
["Hello5World",{"$f":"IFERROR(XLOOKUP(TRUE,ISNUMBER(--MID(A5,SEQUENCE(LEN(A5)),1)),MID(A5,SEQUENCE(LEN(A5)),1),\"\"),\"\")","v":""}]
["Data2025",{"$f":"IFERROR(XLOOKUP(TRUE,ISNUMBER(--MID(A6,SEQUENCE(LEN(A6)),1)),MID(A6,SEQUENCE(LEN(A6)),1),\"\"),\"\")","v":""}]
["X7Series",{"$f":"IFERROR(XLOOKUP(TRUE,ISNUMBER(--MID(A7,SEQUENCE(LEN(A7)),1)),MID(A7,SEQUENCE(LEN(A7)),1),\"\"),\"\")","v":""}]
["Beta123",{"$f":"IFERROR(XLOOKUP(TRUE,ISNUMBER(--MID(A8,SEQUENCE(LEN(A8)),1)),MID(A8,SEQUENCE(LEN(A8)),1),\"\"),\"\")","v":""}]
["Start9Finish",{"$f":"IFERROR(XLOOKUP(TRUE,ISNUMBER(--MID(A9,SEQUENCE(LEN(A9)),1)),MID(A9,SEQUENCE(LEN(A9)),1),\"\"),\"\")","v":""}]
["4RunnerX",{"$f":"IFERROR(XLOOKUP(TRUE,ISNUMBER(--MID(A10,SEQUENCE(LEN(A10)),1)),MID(A10,SEQUENCE(LEN(A10)),1),\"\"),\"\")","v":""}]
["Alpha5Beta6",{"$f":"IFERROR(XLOOKUP(TRUE,ISNUMBER(--MID(A11,SEQUENCE(LEN(A11)),1)),MID(A11,SEQUENCE(LEN(A11)),1),\"\"),\"\")","v":""}]

{"sheet":"INDEX-MATCH","index":1,"n_rows":11,"n_cols":2,"rows_kept":11}
["Text Data","First Number"]
["AB23X9",{"$f":"INDEX(MID(A2,ROW($1:$99),1),MATCH(TRUE,ISNUMBER(--MID(A2,ROW($1:$99),1)),0))","v":"2"}]
["77Test",{"$f":"INDEX(MID(A3,ROW($1:$99),1),MATCH(TRUE,ISNUMBER(--MID(A3,ROW($1:$99),1)),0))","v":"7"}]
["Code9XYZ",{"$f":"INDEX(MID(A4,ROW($1:$99),1),MATCH(TRUE,ISNUMBER(--MID(A4,ROW($1:$99),1)),0))","v":"9"}]
["Hello5World",{"$f":"INDEX(MID(A5,ROW($1:$99),1),MATCH(TRUE,ISNUMBER(--MID(A5,ROW($1:$99),1)),0))","v":"5"}]
["Data2025",{"$f":"INDEX(MID(A6,ROW($1:$99),1),MATCH(TRUE,ISNUMBER(--MID(A6,ROW($1:$99),1)),0))","v":"2"}]
["X7Series",{"$f":"INDEX(MID(A7,ROW($1:$99),1),MATCH(TRUE,ISNUMBER(--MID(A7,ROW($1:$99),1)),0))","v":"7"}]
["Beta123",{"$f":"INDEX(MID(A8,ROW($1:$99),1),MATCH(TRUE,ISNUMBER(--MID(A8,ROW($1:$99),1)),0))","v":"1"}]
["Start9Finish",{"$f":"INDEX(MID(A9,ROW($1:$99),1),MATCH(TRUE,ISNUMBER(--MID(A9,ROW($1:$99),1)),0))","v":"9"}]
["4RunnerX",{"$f":"INDEX(MID(A10,ROW($1:$99),1),MATCH(TRUE,ISNUMBER(--MID(A10,ROW($1:$99),1)),0))","v":"4"}]
["Alpha5Beta6",{"$f":"INDEX(MID(A11,ROW($1:$99),1),MATCH(TRUE,ISNUMBER(--MID(A11,ROW($1:$99),1)),0))","v":"5"}]

{"sheet":"VBA","index":2,"n_rows":11,"n_cols":2,"rows_kept":11}
["Text Data","First Number"]
["AB23X9",{"$f":"FirstDigit(A2)","v":"2"}]
["77Test",{"$f":"FirstDigit(A3)","v":"7"}]
["Code9XYZ","9"]
["Hello5World","5"]
["Data2025","2"]
["X7Series","7"]
["Beta123","1"]
["Start9Finish","9"]
["4RunnerX","4"]
["Alpha5Beta6","5"]

{"sheet":"MATCH+CODE","index":3,"n_rows":11,"n_cols":2,"rows_kept":11}
["Text Data","First Number Position"]
["AB23X9",{"$f":"MATCH(TRUE,ABS(CODE(MID(A2,ROW($A$1:INDEX(A:A,LEN(A2))),1))-52.5)<5,0)","v":3}]
["77Test",{"$f":"MATCH(TRUE,ABS(CODE(MID(A3,ROW($A$1:INDEX(A:A,LEN(A3))),1))-52.5)<5,0)","v":1}]
["Code9XYZ",{"$f":"MATCH(TRUE,ABS(CODE(MID(A4,ROW($A$1:INDEX(A:A,LEN(A4))),1))-52.5)<5,0)","v":5}]
["Hello5World",{"$f":"MATCH(TRUE,ABS(CODE(MID(A5,ROW($A$1:INDEX(A:A,LEN(A5))),1))-52.5)<5,0)","v":6}]
["Data2025",{"$f":"MATCH(TRUE,ABS(CODE(MID(A6,ROW($A$1:INDEX(A:A,LEN(A6))),1))-52.5)<5,0)","v":5}]
["X7Series",{"$f":"MATCH(TRUE,ABS(CODE(MID(A7,ROW($A$1:INDEX(A:A,LEN(A7))),1))-52.5)<5,0)","v":2}]
["Beta123",{"$f":"MATCH(TRUE,ABS(CODE(MID(A8,ROW($A$1:INDEX(A:A,LEN(A8))),1))-52.5)<5,0)","v":5}]
["Start9Finish",{"$f":"MATCH(TRUE,ABS(CODE(MID(A9,ROW($A$1:INDEX(A:A,LEN(A9))),1))-52.5)<5,0)","v":6}]
["4RunnerX",{"$f":"MATCH(TRUE,ABS(CODE(MID(A10,ROW($A$1:INDEX(A:A,LEN(A10))),1))-52.5)<5,0)","v":1}]
["Alpha5Beta6",{"$f":"MATCH(TRUE,ABS(CODE(MID(A11,ROW($A$1:INDEX(A:A,LEN(A11))),1))-52.5)<5,0)","v":6}]

{"sheet":"MID+ FIND","index":4,"n_rows":11,"n_cols":2,"rows_kept":11}
["Text Data","First Number "]
["AB23X9",{"$f":"MID(A2,MIN(FIND({0,1,2,3,4,5,6,7,8,9},A2&\"0123456789\")),1)","v":"2"}]
["77Test",{"$f":"MID(A3,MIN(FIND({0,1,2,3,4,5,6,7,8,9},A3&\"0123456789\")),1)","v":"7"}]
["Code9XYZ",{"$f":"MID(A4,MIN(FIND({0,1,2,3,4,5,6,7,8,9},A4&\"0123456789\")),1)","v":"9"}]
["Hello5World",{"$f":"MID(A5,MIN(FIND({0,1,2,3,4,5,6,7,8,9},A5&\"0123456789\")),1)","v":"5"}]
["Data2025",{"$f":"MID(A6,MIN(FIND({0,1,2,3,4,5,6,7,8,9},A6&\"0123456789\")),1)","v":"2"}]
["X7Series",{"$f":"MID(A7,MIN(FIND({0,1,2,3,4,5,6,7,8,9},A7&\"0123456789\")),1)","v":"7"}]
["Beta123",{"$f":"MID(A8,MIN(FIND({0,1,2,3,4,5,6,7,8,9},A8&\"0123456789\")),1)","v":"1"}]
["Start9Finish",{"$f":"MID(A9,MIN(FIND({0,1,2,3,4,5,6,7,8,9},A9&\"0123456789\")),1)","v":"9"}]
["4RunnerX",{"$f":"MID(A10,MIN(FIND({0,1,2,3,4,5,6,7,8,9},A10&\"0123456789\")),1)","v":"4"}]
["Alpha5Beta6",{"$f":"MID(A11,MIN(FIND({0,1,2,3,4,5,6,7,8,9},A11&\"0123456789\")),1)","v":"5"}]

{"sheet":"MIN + FIND","index":5,"n_rows":11,"n_cols":2,"rows_kept":11}
["Text Data","First Number Position"]
["AB23X9",{"$f":"MIN(FIND({0,1,2,3,4,5,6,7,8,9},A2&\"0123456789\"))","v":3}]
["77Test",{"$f":"MIN(FIND({0,1,2,3,4,5,6,7,8,9},A3&\"0123456789\"))","v":1}]
["Code9XYZ",{"$f":"MIN(FIND({0,1,2,3,4,5,6,7,8,9},A4&\"0123456789\"))","v":5}]
["Hello5World",{"$f":"MIN(FIND({0,1,2,3,4,5,6,7,8,9},A5&\"0123456789\"))","v":6}]
["Data2025",{"$f":"MIN(FIND({0,1,2,3,4,5,6,7,8,9},A6&\"0123456789\"))","v":5}]
["X7Series",{"$f":"MIN(FIND({0,1,2,3,4,5,6,7,8,9},A7&\"0123456789\"))","v":2}]
["Beta123",{"$f":"MIN(FIND({0,1,2,3,4,5,6,7,8,9},A8&\"0123456789\"))","v":5}]
["Start9Finish",{"$f":"MIN(FIND({0,1,2,3,4,5,6,7,8,9},A9&\"0123456789\"))","v":6}]
["4RunnerX",{"$f":"MIN(FIND({0,1,2,3,4,5,6,7,8,9},A10&\"0123456789\"))","v":1}]
["Alpha5Beta6",{"$f":"MIN(FIND({0,1,2,3,4,5,6,7,8,9},A11&\"0123456789\"))","v":6}]