{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Sheet2"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":1,"defined_names":34,"comments":1,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Sheet2","index":0,"n_rows":366,"n_cols":26,"rows_kept":366,"cut":false,"hidden":false,"merged":[]}
[null,"Raw string:"]
[null,"Jeff Weir Age: 43 DOB: 25/4/71 Salary: $100,000.00 StartTime: 8:30","<<< Choose from picklist. Add your own strings below."]
[]
[null,"Amended String:",null,null,null,null,"Formula1",{"$f":"_xlfn.FORMULATEXT(H6)","v":"{=MID(String,ROW(OFFSET($A$1,,,LEN(String)))*COLUMN(OFFSET($A$1,,,,LEN(String)))^0,COLUMN(OFFSET($A$1,,,,LEN(String)))*ROW(OFFSET($A$1,,,LEN(String)))^0)}"}]
[null,{"$f":"SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(B2,\" \",\"|\"),\"$\",\"\"),\",\",\"\")","v":"Jeff|Weir|Age:|43|DOB:|25/4/71|Salary:|100000.00|StartTime:|8:30"},null,null,null,null,"Substring Length >>  ",1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19]
[null,null,null,null,null,{"$f":"MID(String,ROW(OFFSET($A$1,,,LEN(String))),1)","v":"J"},1,{"$f":"MID(String,ROW(OFFSET($A$1,,,LEN(String)))*COLUMN(OFFSET($A$1,,,,LEN(String)))^0,COLUMN(OFFSET($A$1,,,,LEN(String)))*ROW(OFFSET($A$1,,,LEN(String)))^0)","v":"J"},"Je","Jef","Jeff","Jeff|","Jeff|W","Jeff|We","Jeff|Wei","Jeff|Weir","Jeff|Weir|","Jeff|Weir|A","Jeff|Weir|Ag","Jeff|Weir|Age","Jeff|Weir|Age:","Jeff|Weir|Age:|","Jeff|Weir|Age:|4","Jeff|Weir|Age:|43","Jeff|Weir|Age:|43|","Jeff|Weir|Age:|43|D"]
[null,"Jeff:","XOR:",null,null,"e",2,"e","ef","eff","eff|","eff|W","eff|We","eff|Wei","eff|Weir","eff|Weir|","eff|Weir|A","eff|Weir|Ag","eff|Weir|Age","eff|Weir|Age:","eff|Weir|Age:|","eff|Weir|Age:|4","eff|Weir|Age:|43","eff|Weir|Age:|43|","eff|Weir|Age:|43|D","eff|Weir|Age:|43|DO"]
[1,{"$f":"MID(String,SMALL(IF((FREQUENCY(ISNUMBER(-MID(String,ROW(OFFSET($A$1,,,LEN(String)))*COLUMN(OFFSET($A$1,,,,LEN(String)))^0,COLUMN(OFFSET($A$1,,,,LEN(String)))*ROW(OFFSET($A$1,,,LEN(String)))^0))*(COLUMN(OFFSET($A$1,,,,LEN(String)))+ROW(OFFSET($A$1,,,LEN(String)))-1),ROW(OFFSET($A$1,,,LEN(String)+1))-1)=1)*ISNUMBER(-MID(\"|\"&String&\"|\",ROW(OFFSET($A$1,,,LEN(String)+2)),1))=1,ROW(OFFSET($A$1,,,LEN(String)+2))-1,FALSE),ROW(OFFSET($A$1,,,LEN(String)))),SMALL(IF((FREQUENCY(ISNUMBER(-MID(String&\"|\",ROW(OFFSET($A$1,,,LEN(String)))*COLUMN(OFFSET($A$1,,,,LEN(String)))^0,COLUMN(OFFSET($A$1,,,,LEN(String)))*ROW(OFFSET($A$1,,,LEN(String)))^0))*(LEN(String)+1-ROW(OFFSET($A$1,,,LEN(String)))),MOD(LEN(String)+2-ROW(OFFSET($A$1,,,LEN(String)+1)),LEN(String)+1))=1)*ISNUMBER(-MID(\"|\"&String,ROW(OFFSET($A$1,,,LEN(String)+2)),1))=1,ROW(OFFSET($A$1,,,LEN(String)+2))-1,FALSE),ROW(OFFSET($A$1,,,LEN(String))))-SMALL(IF((FREQUENCY(ISNUMBER(-MID(String,ROW(OFFSET($A$1,,,LEN(String)))*COLUMN(OFFSET($A$1,,,,LEN(String)))^0,COLUMN(OFFSET($A$1,,,,LEN(String)))*ROW(OFFSET($A$1,,,LEN(String)))^0))*(COLUMN(OFFSET($A$1,,,,LEN(String)))+ROW(OFFSET($A$1,,,LEN(String)))-1),ROW(OFFSET($A$1,,,LEN(String)+1))-1)=1)*ISNUMBER(-MID(\"|\"&String&\"|\",ROW(OFFSET($A$1,,,LEN(String)+2)),1))=1,ROW(OFFSET($A$1,,,LEN(String)+2))-1,FALSE),ROW(OFFSET($A$1,,,LEN(String))))+1)","v":"43"},{"$f":"0+MID(\"α\"&String&\"α0\",1+SMALL(IF(MMULT(0+(ABS(51.5-CODE(MID(SUBSTITUTE(\"α\"&String&\"α0\",\"/\",\"α\"),ROW(INDIRECT(\"1:\"&LEN(\"α\"&String&\"α0\")-1))+{0,1},1)))>6)*{2,1},{1;1})=2,ROW(INDIRECT(\"1:\"&LEN(\"α\"&String&\"α0\")-1))),A8),SUM(SMALL(IF(ISNUMBER(MATCH(MMULT(0+(ABS(51.5-CODE(MID(SUBSTITUTE(\"α\"&String&\"α0\",\"/\",\"α\"),ROW(INDIRECT(\"1:\"&LEN(\"α\"&String&\"α0\")-1))+{0,1},1)))>6)*{2,1},{1;1}),{1,2},0)),ROW(INDIRECT(\"1:\"&LEN(\"α\"&String&\"α0\")-1))),2*A8+{-1,0})*{-1,1}))","v":43},null,null,"f",3,"f","ff","ff|","ff|W","ff|We","ff|Wei","ff|Weir","ff|Weir|","ff|Weir|A","ff|Weir|Ag","ff|Weir|Age","ff|Weir|Age:","ff|Weir|Age:|","ff|Weir|Age:|4","ff|Weir|Age:|43","ff|Weir|Age:|43|","ff|Weir|Age:|43|D","ff|Weir|Age:|43|DO","ff|Weir|Age:|43|DOB"]
[2,"25/4/71",{"$f":"0+MID(\"α\"&String&\"α0\",1+SMALL(IF(MMULT(0+(ABS(51.5-CODE(MID(SUBSTITUTE(\"α\"&String&\"α0\",\"/\",\"α\"),ROW(INDIRECT(\"1:\"&LEN(\"α\"&String&\"α0\")-1))+{0,1},1)))>6)*{2,1},{1;1})=2,ROW(INDIRECT(\"1:\"&LEN(\"α\"&String&\"α0\")-1))),A9),SUM(SMALL(IF(ISNUMBER(MATCH(MMULT(0+(ABS(51.5-CODE(MID(SUBSTITUTE(\"α\"&String&\"α0\",\"/\",\"α\"),ROW(INDIRECT(\"1:\"&LEN(\"α\"&String&\"α0\")-1))+{0,1},1)))>6)*{2,1},{1;1}),{1,2},0)),ROW(INDIRECT(\"1:\"&LEN(\"α\"&String&\"α0\")-1))),2*A9+{-1,0})*{-1,1}))","v":25},null,null,"f",4,"f","f|","f|W","f|We","f|Wei","f|Weir","f|Weir|","f|Weir|A","f|Weir|Ag","f|Weir|Age","f|Weir|Age:","f|Weir|Age:|","f|Weir|Age:|4","f|Weir|Age:|43","f|Weir|Age:|43|","f|Weir|Age:|43|D","f|Weir|Age:|43|DO","f|Weir|Age:|43|DOB","f|Weir|Age:|43|DOB:"]
[3,"100000.00",{"$f":"0+MID(\"α\"&String&\"α0\",1+SMALL(IF(MMULT(0+(ABS(51.5-CODE(MID(SUBSTITUTE(\"α\"&String&\"α0\",\"/\",\"α\"),ROW(INDIRECT(\"1:\"&LEN(\"α\"&String&\"α0\")-1))+{0,1},1)))>6)*{2,1},{1;1})=2,ROW(INDIRECT(\"1:\"&LEN(\"α\"&String&\"α0\")-1))),A10),SUM(SMALL(IF(ISNUMBER(MATCH(MMULT(0+(ABS(51.5-CODE(MID(SUBSTITUTE(\"α\"&String&\"α0\",\"/\",\"α\"),ROW(INDIRECT(\"1:\"&LEN(\"α\"&String&\"α0\")-1))+{0,1},1)))>6)*{2,1},{1;1}),{1,2},0)),ROW(INDIRECT(\"1:\"&LEN(\"α\"&String&\"α0\")-1))),2*A10+{-1,0})*{-1,1}))","v":4},null,null,"|",5,"|","|W","|We","|Wei","|Weir","|Weir|","|Weir|A","|Weir|Ag","|Weir|Age","|Weir|Age:","|Weir|Age:|","|Weir|Age:|4","|Weir|Age:|43","|Weir|Age:|43|","|Weir|Age:|43|D","|Weir|Age:|43|DO","|Weir|Age:|43|DOB","|Weir|Age:|43|DOB:","|Weir|Age:|43|DOB:|"]
[4,"8:30",{"$f":"0+MID(\"α\"&String&\"α0\",1+SMALL(IF(MMULT(0+(ABS(51.5-CODE(MID(SUBSTITUTE(\"α\"&String&\"α0\",\"/\",\"α\"),ROW(INDIRECT(\"1:\"&LEN(\"α\"&String&\"α0\")-1))+{0,1},1)))>6)*{2,1},{1;1})=2,ROW(INDIRECT(\"1:\"&LEN(\"α\"&String&\"α0\")-1))),A11),SUM(SMALL(IF(ISNUMBER(MATCH(MMULT(0+(ABS(51.5-CODE(MID(SUBSTITUTE(\"α\"&String&\"α0\",\"/\",\"α\"),ROW(INDIRECT(\"1:\"&LEN(\"α\"&String&\"α0\")-1))+{0,1},1)))>6)*{2,1},{1;1}),{1,2},0)),ROW(INDIRECT(\"1:\"&LEN(\"α\"&String&\"α0\")-1))),2*A11+{-1,0})*{-1,1}))","v":71},null,null,"W",6,"W","We","Wei","Weir","Weir|","Weir|A","Weir|Ag","Weir|Age","Weir|Age:","Weir|Age:|","Weir|Age:|4","Weir|Age:|43","Weir|Age:|43|","Weir|Age:|43|D","Weir|Age:|43|DO","Weir|Age:|43|DOB","Weir|Age:|43|DOB:","Weir|Age:|43|DOB:|","Weir|Age:|43|DOB:|2"]
[5,{"$error":"#NUM!"},{"$f":"0+MID(\"α\"&String&\"α0\",1+SMALL(IF(MMULT(0+(ABS(51.5-CODE(MID(SUBSTITUTE(\"α\"&String&\"α0\",\"/\",\"α\"),ROW(INDIRECT(\"1:\"&LEN(\"α\"&String&\"α0\")-1))+{0,1},1)))>6)*{2,1},{1;1})=2,ROW(INDIRECT(\"1:\"&LEN(\"α\"&String&\"α0\")-1))),A12),SUM(SMALL(IF(ISNUMBER(MATCH(MMULT(0+(ABS(51.5-CODE(MID(SUBSTITUTE(\"α\"&String&\"α0\",\"/\",\"α\"),ROW(INDIRECT(\"1:\"&LEN(\"α\"&String&\"α0\")-1))+{0,1},1)))>6)*{2,1},{1;1}),{1,2},0)),ROW(INDIRECT(\"1:\"&LEN(\"α\"&String&\"α0\")-1))),2*A12+{-1,0})*{-1,1}))","v":100000},null,null,"e",7,"e","ei","eir","eir|","eir|A","eir|Ag","eir|Age","eir|Age:","eir|Age:|","eir|Age:|4","eir|Age:|43","eir|Age:|43|","eir|Age:|43|D","eir|Age:|43|DO","eir|Age:|43|DOB","eir|Age:|43|DOB:","eir|Age:|43|DOB:|","eir|Age:|43|DOB:|2","eir|Age:|43|DOB:|25"]
[6,{"$error":"#NUM!"},{"$f":"0+MID(\"α\"&String&\"α0\",1+SMALL(IF(MMULT(0+(ABS(51.5-CODE(MID(SUBSTITUTE(\"α\"&String&\"α0\",\"/\",\"α\"),ROW(INDIRECT(\"1:\"&LEN(\"α\"&String&\"α0\")-1))+{0,1},1)))>6)*{2,1},{1;1})=2,ROW(INDIRECT(\"1:\"&LEN(\"α\"&String&\"α0\")-1))),A13),SUM(SMALL(IF(ISNUMBER(MATCH(MMULT(0+(ABS(51.5-CODE(MID(SUBSTITUTE(\"α\"&String&\"α0\",\"/\",\"α\"),ROW(INDIRECT(\"1:\"&LEN(\"α\"&String&\"α0\")-1))+{0,1},1)))>6)*{2,1},{1;1}),{1,2},0)),ROW(INDIRECT(\"1:\"&LEN(\"α\"&String&\"α0\")-1))),2*A13+{-1,0})*{-1,1}))","v":8},null,null,"i",8,"i","ir","ir|","ir|A","ir|Ag","ir|Age","ir|Age:","ir|Age:|","ir|Age:|4","ir|Age:|43","ir|Age:|43|","ir|Age:|43|D","ir|Age:|43|DO","ir|Age:|43|DOB","ir|Age:|43|DOB:","ir|Age:|43|DOB:|","ir|Age:|43|DOB:|2","ir|Age:|43|DOB:|25","ir|Age:|43|DOB:|25/"]
[7,{"$error":"#NUM!"},{"$f":"0+MID(\"α\"&String&\"α0\",1+SMALL(IF(MMULT(0+(ABS(51.5-CODE(MID(SUBSTITUTE(\"α\"&String&\"α0\",\"/\",\"α\"),ROW(INDIRECT(\"1:\"&LEN(\"α\"&String&\"α0\")-1))+{0,1},1)))>6)*{2,1},{1;1})=2,ROW(INDIRECT(\"1:\"&LEN(\"α\"&String&\"α0\")-1))),A14),SUM(SMALL(IF(ISNUMBER(MATCH(MMULT(0+(ABS(51.5-CODE(MID(SUBSTITUTE(\"α\"&String&\"α0\",\"/\",\"α\"),ROW(INDIRECT(\"1:\"&LEN(\"α\"&String&\"α0\")-1))+{0,1},1)))>6)*{2,1},{1;1}),{1,2},0)),ROW(INDIRECT(\"1:\"&LEN(\"α\"&String&\"α0\")-1))),2*A14+{-1,0})*{-1,1}))","v":30},null,null,"r",9,"r","r|","r|A","r|Ag","r|Age","r|Age:","r|Age:|","r|Age:|4","r|Age:|43","r|Age:|43|","r|Age:|43|D","r|Age:|43|DO","r|Age:|43|DOB","r|Age:|43|DOB:","r|Age:|43|DOB:|","r|Age:|43|DOB:|2","r|Age:|43|DOB:|25","r|Age:|43|DOB:|25/","r|Age:|43|DOB:|25/4"]
[8,{"$error":"#NUM!"},{"$f":"0+MID(\"α\"&String&\"α0\",1+SMALL(IF(MMULT(0+(ABS(51.5-CODE(MID(SUBSTITUTE(\"α\"&String&\"α0\",\"/\",\"α\"),ROW(INDIRECT(\"1:\"&LEN(\"α\"&String&\"α0\")-1))+{0,1},1)))>6)*{2,1},{1;1})=2,ROW(INDIRECT(\"1:\"&LEN(\"α\"&String&\"α0\")-1))),A15),SUM(SMALL(IF(ISNUMBER(MATCH(MMULT(0+(ABS(51.5-CODE(MID(SUBSTITUTE(\"α\"&String&\"α0\",\"/\",\"α\"),ROW(INDIRECT(\"1:\"&LEN(\"α\"&String&\"α0\")-1))+{0,1},1)))>6)*{2,1},{1;1}),{1,2},0)),ROW(INDIRECT(\"1:\"&LEN(\"α\"&String&\"α0\")-1))),2*A15+{-1,0})*{-1,1}))","v":{"$error":"#NUM!"}},null,null,"|",10,"|","|A","|Ag","|Age","|Age:","|Age:|","|Age:|4","|Age:|43","|Age:|43|","|Age:|43|D","|Age:|43|DO","|Age:|43|DOB","|Age:|43|DOB:","|Age:|43|DOB:|","|Age:|43|DOB:|2","|Age:|43|DOB:|25","|Age:|43|DOB:|25/","|Age:|43|DOB:|25/4","|Age:|43|DOB:|25/4/"]
[9,{"$error":"#NUM!"},{"$f":"0+MID(\"α\"&String&\"α0\",1+SMALL(IF(MMULT(0+(ABS(51.5-CODE(MID(SUBSTITUTE(\"α\"&String&\"α0\",\"/\",\"α\"),ROW(INDIRECT(\"1:\"&LEN(\"α\"&String&\"α0\")-1))+{0,1},1)))>6)*{2,1},{1;1})=2,ROW(INDIRECT(\"1:\"&LEN(\"α\"&String&\"α0\")-1))),A16),SUM(SMALL(IF(ISNUMBER(MATCH(MMULT(0+(ABS(51.5-CODE(MID(SUBSTITUTE(\"α\"&String&\"α0\",\"/\",\"α\"),ROW(INDIRECT(\"1:\"&LEN(\"α\"&String&\"α0\")-1))+{0,1},1)))>6)*{2,1},{1;1}),{1,2},0)),ROW(INDIRECT(\"1:\"&LEN(\"α\"&String&\"α0\")-1))),2*A16+{-1,0})*{-1,1}))","v":{"$error":"#NUM!"}},null,null,"A",11,"A","Ag","Age","Age:","Age:|","Age:|4","Age:|43","Age:|43|","Age:|43|D","Age:|43|DO","Age:|43|DOB","Age:|43|DOB:","Age:|43|DOB:|","Age:|43|DOB:|2","Age:|43|DOB:|25","Age:|43|DOB:|25/","Age:|43|DOB:|25/4","Age:|43|DOB:|25/4/","Age:|43|DOB:|25/4/7"]
[10,{"$error":"#NUM!"},{"$f":"0+MID(\"α\"&String&\"α0\",1+SMALL(IF(MMULT(0+(ABS(51.5-CODE(MID(SUBSTITUTE(\"α\"&String&\"α0\",\"/\",\"α\"),ROW(INDIRECT(\"1:\"&LEN(\"α\"&String&\"α0\")-1))+{0,1},1)))>6)*{2,1},{1;1})=2,ROW(INDIRECT(\"1:\"&LEN(\"α\"&String&\"α0\")-1))),A17),SUM(SMALL(IF(ISNUMBER(MATCH(MMULT(0+(ABS(51.5-CODE(MID(SUBSTITUTE(\"α\"&String&\"α0\",\"/\",\"α\"),ROW(INDIRECT(\"1:\"&LEN(\"α\"&String&\"α0\")-1))+{0,1},1)))>6)*{2,1},{1;1}),{1,2},0)),ROW(INDIRECT(\"1:\"&LEN(\"α\"&String&\"α0\")-1))),2*A17+{-1,0})*{-1,1}))","v":{"$error":"#NUM!"}},null,null,"g",12,"g","ge","ge:","ge:|","ge:|4","ge:|43","ge:|43|","ge:|43|D","ge:|43|DO","ge:|43|DOB","ge:|43|DOB:","ge:|43|DOB:|","ge:|43|DOB:|2","ge:|43|DOB:|25","ge:|43|DOB:|25/","ge:|43|DOB:|25/4","ge:|43|DOB:|25/4/","ge:|43|DOB:|25/4/7","ge:|43|DOB:|25/4/71"]
[11,{"$error":"#NUM!"},{"$f":"0+MID(\"α\"&String&\"α0\",1+SMALL(IF(MMULT(0+(ABS(51.5-CODE(MID(SUBSTITUTE(\"α\"&String&\"α0\",\"/\",\"α\"),ROW(INDIRECT(\"1:\"&LEN(\"α\"&String&\"α0\")-1))+{0,1},1)))>6)*{2,1},{1;1})=2,ROW(INDIRECT(\"1:\"&LEN(\"α\"&String&\"α0\")-1))),A18),SUM(SMALL(IF(ISNUMBER(MATCH(MMULT(0+(ABS(51.5-CODE(MID(SUBSTITUTE(\"α\"&String&\"α0\",\"/\",\"α\"),ROW(INDIRECT(\"1:\"&LEN(\"α\"&String&\"α0\")-1))+{0,1},1)))>6)*{2,1},{1;1}),{1,2},0)),ROW(INDIRECT(\"1:\"&LEN(\"α\"&String&\"α0\")-1))),2*A18+{-1,0})*{-1,1}))","v":{"$error":"#NUM!"}},null,null,"e",13,"e","e:","e:|","e:|4","e:|43","e:|43|","e:|43|D","e:|43|DO","e:|43|DOB","e:|43|DOB:","e:|43|DOB:|","e:|43|DOB:|2","e:|43|DOB:|25","e:|43|DOB:|25/","e:|43|DOB:|25/4","e:|43|DOB:|25/4/","e:|43|DOB:|25/4/7","e:|43|DOB:|25/4/71","e:|43|DOB:|25/4/71|"]
[12,{"$error":"#NUM!"},{"$f":"0+MID(\"α\"&String&\"α0\",1+SMALL(IF(MMULT(0+(ABS(51.5-CODE(MID(SUBSTITUTE(\"α\"&String&\"α0\",\"/\",\"α\"),ROW(INDIRECT(\"1:\"&LEN(\"α\"&String&\"α0\")-1))+{0,1},1)))>6)*{2,1},{1;1})=2,ROW(INDIRECT(\"1:\"&LEN(\"α\"&String&\"α0\")-1))),A19),SUM(SMALL(IF(ISNUMBER(MATCH(MMULT(0+(ABS(51.5-CODE(MID(SUBSTITUTE(\"α\"&String&\"α0\",\"/\",\"α\"),ROW(INDIRECT(\"1:\"&LEN(\"α\"&String&\"α0\")-1))+{0,1},1)))>6)*{2,1},{1;1}),{1,2},0)),ROW(INDIRECT(\"1:\"&LEN(\"α\"&String&\"α0\")-1))),2*A19+{-1,0})*{-1,1}))","v":{"$error":"#NUM!"}},null,null,":",14,":",":|",":|4",":|43",":|43|",":|43|D",":|43|DO",":|43|DOB",":|43|DOB:",":|43|DOB:|",":|43|DOB:|2",":|43|DOB:|25",":|43|DOB:|25/",":|43|DOB:|25/4",":|43|DOB:|25/4/",":|43|DOB:|25/4/7",":|43|DOB:|25/4/71",":|43|DOB:|25/4/71|",":|43|DOB:|25/4/71|S"]
[13,{"$error":"#NUM!"},{"$f":"0+MID(\"α\"&String&\"α0\",1+SMALL(IF(MMULT(0+(ABS(51.5-CODE(MID(SUBSTITUTE(\"α\"&String&\"α0\",\"/\",\"α\"),ROW(INDIRECT(\"1:\"&LEN(\"α\"&String&\"α0\")-1))+{0,1},1)))>6)*{2,1},{1;1})=2,ROW(INDIRECT(\"1:\"&LEN(\"α\"&String&\"α0\")-1))),A20),SUM(SMALL(IF(ISNUMBER(MATCH(MMULT(0+(ABS(51.5-CODE(MID(SUBSTITUTE(\"α\"&String&\"α0\",\"/\",\"α\"),ROW(INDIRECT(\"1:\"&LEN(\"α\"&String&\"α0\")-1))+{0,1},1)))>6)*{2,1},{1;1}),{1,2},0)),ROW(INDIRECT(\"1:\"&LEN(\"α\"&String&\"α0\")-1))),2*A20+{-1,0})*{-1,1}))","v":{"$error":"#NUM!"}},null,null,"|",15,"|","|4","|43","|43|","|43|D","|43|DO","|43|DOB","|43|DOB:","|43|DOB:|","|43|DOB:|2","|43|DOB:|25","|43|DOB:|25/","|43|DOB:|25/4","|43|DOB:|25/4/","|43|DOB:|25/4/7","|43|DOB:|25/4/71","|43|DOB:|25/4/71|","|43|DOB:|25/4/71|S","|43|DOB:|25/4/71|Sa"]
[null,null,null,null,null,"4",16,"4","43","43|","43|D","43|DO","43|DOB","43|DOB:","43|DOB:|","43|DOB:|2","43|DOB:|25","43|DOB:|25/","43|DOB:|25/4","43|DOB:|25/4/","43|DOB:|25/4/7","43|DOB:|25/4/71","43|DOB:|25/4/71|","43|DOB:|25/4/71|S","43|DOB:|25/4/71|Sa","43|DOB:|25/4/71|Sal"]
[null,null,null,null,null,"3",17,"3","3|","3|D","3|DO","3|DOB","3|DOB:","3|DOB:|","3|DOB:|2","3|DOB:|25","3|DOB:|25/","3|DOB:|25/4","3|DOB:|25/4/","3|DOB:|25/4/7","3|DOB:|25/4/71","3|DOB:|25/4/71|","3|DOB:|25/4/71|S","3|DOB:|25/4/71|Sa","3|DOB:|25/4/71|Sal","3|DOB:|25/4/71|Sala"]
[null,"Test Strings",null,null,null,"|",18,"|","|D","|DO","|DOB","|DOB:","|DOB:|","|DOB:|2","|DOB:|25","|DOB:|25/","|DOB:|25/4","|DOB:|25/4/","|DOB:|25/4/7","|DOB:|25/4/71","|DOB:|25/4/71|","|DOB:|25/4/71|S","|DOB:|25/4/71|Sa","|DOB:|25/4/71|Sal","|DOB:|25/4/71|Sala","|DOB:|25/4/71|Salar"]
[null,"81;8.75>@5279@4.=45>A?A;",null,null,null,"D",19,"D","DO","DOB","DOB:","DOB:|","DOB:|2","DOB:|25","DOB:|25/","DOB:|25/4","DOB:|25/4/","DOB:|25/4/7","DOB:|25/4/71","DOB:|25/4/71|","DOB:|25/4/71|S","DOB:|25/4/71|Sa","DOB:|25/4/71|Sal","DOB:|25/4/71|Sala","DOB:|25/4/71|Salar","DOB:|25/4/71|Salary"]
[null,"25/4/71s50.2pp5:38"]
[null,"Jeff is 44 on 25/4/2015",null,null,null,null,"Formula2",{"$f":"_xlfn.FORMULATEXT(H29)","v":"{=ISNUMBER(-MID(String,ROW(OFFSET($A$1,,,LEN(String)))*COLUMN(OFFSET($A$1,,,,LEN(String)))^0,COLUMN(OFFSET($A$1,,,,LEN(String)))*ROW(OFFSET($A$1,,,LEN(String)))^0))}"}]
[null,"I owe you $20,002 USD",null,null,null,null,null,{"$f":"SUBSTITUTE(_xlfn.FORMULATEXT(H29),MID(Formula1,FIND(\"=\",Formula1)+1,LEN(Formula1)-IF(LEFT(Formula1)=\"{\",1,0)-IF(RIGHT(Formula1)=\"}\",1,0)-1),Formula1_Label)","v":"{=ISNUMBER(-Formula1)}"}]
[null,"I owe you $20,002 USD, not $20,002,000 USD!",null,null,null,null,"Substring Length >>  ",1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19]
[null,"I owe you $20,002.01 USD, not $20,002,000.01 USD!",null,null,null,{"$f":"MID(String,ROW(OFFSET($A$1,,,LEN(String))),1)","v":"J"},1,{"$f":"ISNUMBER(-MID(String,ROW(OFFSET($A$1,,,LEN(String)))*COLUMN(OFFSET($A$1,,,,LEN(String)))^0,COLUMN(OFFSET($A$1,,,,LEN(String)))*ROW(OFFSET($A$1,,,LEN(String)))^0))","v":false},false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false]
[null,"Jeff Weir Age: 43 DOB: 25/4/71 Salary: $100,000.00 StartTime: 8:30",null,null,null,"e",2,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false]
[null,"a1bb22ccc333dd4444",null,null,null,"f",3,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false]
[null,null,null,null,null,"f",4,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false]
[null,null,null,null,null,"|",5,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false]
[null,null,null,null,null,"W",6,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false]
[null,null,null,null,null,"e",7,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false]
[null,null,null,null,null,"i",8,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false]
[null,null,null,null,null,"r",9,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false]
[null,null,null,null,null,"|",10,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false]
[null,null,null,null,null,"A",11,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false]
[null,null,null,null,null,"g",12,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false]
[null,null,null,null,null,"e",13,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false]
[null,null,null,null,null,":",14,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false]
[null,null,null,null,null,"|",15,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false]
[null,null,null,null,null,"4",16,true,true,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false]
[null,null,null,null,null,"3",17,true,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false]
[null,null,null,null,null,"|",18,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false]
[null,null,null,null,null,"D",19,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false]
[]
[]
[null,null,null,null,null,null,"Formula3a",{"$f":"_xlfn.FORMULATEXT(H53)","v":"{=ISNUMBER(-MID(String,ROW(OFFSET($A$1,,,LEN(String)))*COLUMN(OFFSET($A$1,,,,LEN(String)))^0,COLUMN(OFFSET($A$1,,,,LEN(String)))*ROW(OFFSET($A$1,,,LEN(String)))^0))*(COLUMN(OFFSET($A$1,,,,LEN(String)))+ROW(OFFSET($A$1,,,LEN(String)))-1)}"}]
[null,null,null,null,null,null,null,{"$f":"SUBSTITUTE(_xlfn.FORMULATEXT(H53),MID(Formula2,FIND(\"=\",Formula2)+1,LEN(Formula2)-IF(LEFT(Formula2)=\"{\",1,0)-IF(RIGHT(Formula2)=\"}\",1,0)-1),Formula2_Label)","v":"{=Formula2*(COLUMN(OFFSET($A$1,,,,LEN(String)))+ROW(OFFSET($A$1,,,LEN(String)))-1)}"}]
[null,null,null,null,null,null,"Substring Length >>  ",1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19]
[null,null,null,null,null,{"$f":"MID(String,ROW(OFFSET($A$1,,,LEN(String))),1)","v":"J"},1,{"$f":"ISNUMBER(-MID(String,ROW(OFFSET($A$1,,,LEN(String)))*COLUMN(OFFSET($A$1,,,,LEN(String)))^0,COLUMN(OFFSET($A$1,,,,LEN(String)))*ROW(OFFSET($A$1,,,LEN(String)))^0))*(COLUMN(OFFSET($A$1,,,,LEN(String)))+ROW(OFFSET($A$1,,,LEN(String)))-1)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,"e",2,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,"f",3,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,"f",4,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,"|",5,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,"W",6,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,"e",7,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,"i",8,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,"r",9,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,"|",10,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,"A",11,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,"g",12,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,"e",13,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,":",14,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,"|",15,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,"4",16,16,17,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,"3",17,17,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,"|",18,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,"D",19,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[]
[null,null,null,null,null,null,"Formula4a",{"$f":"_xlfn.FORMULATEXT(H77)","v":"{=FREQUENCY(ISNUMBER(-MID(String,ROW(OFFSET($A$1,,,LEN(String)))*COLUMN(OFFSET($A$1,,,,LEN(String)))^0,COLUMN(OFFSET($A$1,,,,LEN(String)))*ROW(OFFSET($A$1,,,LEN(String)))^0))*(COLUMN(OFFSET($A$1,,,,LEN(String)))+ROW(OFFSET($A$1,,,LEN(String)))-1),ROW(OFFSET($A$1,,,LEN(String)+1))-1)}"}]
[null,null,null,null,null,null,null,{"$f":"SUBSTITUTE(_xlfn.FORMULATEXT(H77),MID(Formula3,FIND(\"=\",Formula3)+1,LEN(Formula3)-IF(LEFT(Formula3)=\"{\",1,0)-IF(RIGHT(Formula3)=\"}\",1,0)-1),Formula3_Label)","v":"{=FREQUENCY(Formula3a,ROW(OFFSET($A$1,,,LEN(String)+1))-1)}"}]
[null,null,null,null,null,null,"Position"]
[null,null,null,null,null,null,0,{"$f":"FREQUENCY(ISNUMBER(-MID(String,ROW(OFFSET($A$1,,,LEN(String)))*COLUMN(OFFSET($A$1,,,,LEN(String)))^0,COLUMN(OFFSET($A$1,,,,LEN(String)))*ROW(OFFSET($A$1,,,LEN(String)))^0))*(COLUMN(OFFSET($A$1,,,,LEN(String)))+ROW(OFFSET($A$1,,,LEN(String)))-1),ROW(OFFSET($A$1,,,LEN(String)+1))-1)","v":3842}]
[null,null,null,null,null,{"$f":"MID(String,ROW(OFFSET($A$1,,,LEN(String))),1)","v":"J"},1,0]
[null,null,null,null,null,"e",2,0]
[null,null,null,null,null,"f",3,0]
[null,null,null,null,null,"f",4,0]
[null,null,null,null,null,"|",5,0]
[null,null,null,null,null,"W",6,0]
[null,null,null,null,null,"e",7,0]
[null,null,null,null,null,"i",8,0]
[null,null,null,null,null,"r",9,0]
[null,null,null,null,null,"|",10,0]
[null,null,null,null,null,"A",11,0]
[null,null,null,null,null,"g",12,0]
[null,null,null,null,null,"e",13,0]
[null,null,null,null,null,":",14,0]
[null,null,null,null,null,"|",15,0]
[null,null,null,null,null,"4",16,1]
[null,null,null,null,null,"3",17,2]
[null,null,null,null,null,"|",18,0]
[null,null,null,null,null,"D",19,0]
[null,null,null,null,null,null,">19",0]
[]
[null,null,null,null,null,null,"Formula5",{"$f":"_xlfn.FORMULATEXT(H102)","v":"{=FREQUENCY(ISNUMBER(-MID(String,ROW(OFFSET($A$1,,,LEN(String)))*COLUMN(OFFSET($A$1,,,,LEN(String)))^0,COLUMN(OFFSET($A$1,,,,LEN(String)))*ROW(OFFSET($A$1,,,LEN(String)))^0))*(COLUMN(OFFSET($A$1,,,,LEN(String)))+ROW(OFFSET($A$1,,,LEN(String)))-1),ROW(OFFSET($A$1,,,LEN(String)+1))-1)=1}"}]
[null,null,null,null,null,null,null,{"$f":"SUBSTITUTE(_xlfn.FORMULATEXT(H102),MID(Formula4,FIND(\"=\",Formula4)+1,LEN(Formula4)-IF(LEFT(Formula4)=\"{\",1,0)-IF(RIGHT(Formula4)=\"}\",1,0)-1),Formula4_Label)","v":"{=Formula4a=1}"}]
[null,null,null,null,null,null,"Position"]
[null,null,null,null,null,null,0,{"$f":"FREQUENCY(ISNUMBER(-MID(String,ROW(OFFSET($A$1,,,LEN(String)))*COLUMN(OFFSET($A$1,,,,LEN(String)))^0,COLUMN(OFFSET($A$1,,,,LEN(String)))*ROW(OFFSET($A$1,,,LEN(String)))^0))*(COLUMN(OFFSET($A$1,,,,LEN(String)))+ROW(OFFSET($A$1,,,LEN(String)))-1),ROW(OFFSET($A$1,,,LEN(String)+1))-1)=1","v":false}]
[null,null,null,null,null,{"$f":"MID(String,ROW(OFFSET($A$1,,,LEN(String))),1)","v":"J"},1,false]
[null,null,null,null,null,"e",2,false]
[null,null,null,null,null,"f",3,false]
[null,null,null,null,null,"f",4,false]
[null,null,null,null,null,"|",5,false]
[null,null,null,null,null,"W",6,false]
[null,null,null,null,null,"e",7,false]
[null,null,null,null,null,"i",8,false]
[null,null,null,null,null,"r",9,false]
[null,null,null,null,null,"|",10,false]
[null,null,null,null,null,"A",11,false]
[null,null,null,null,null,"g",12,false]
[null,null,null,null,null,"e",13,false]
[null,null,null,null,null,":",14,false]
[null,null,null,null,null,"|",15,false]
[null,null,null,null,null,"4",16,true]
[null,null,null,null,null,"3",17,false]
[null,null,null,null,null,"|",18,false]
[null,null,null,null,null,"D",19,false]
[null,null,null,null,null,null,">19",false]
[]
[null,null,null,null,null,null,"Formula6",{"$f":"_xlfn.FORMULATEXT(H127)","v":"{=(FREQUENCY(ISNUMBER(-MID(String,ROW(OFFSET($A$1,,,LEN(String)))*COLUMN(OFFSET($A$1,,,,LEN(String)))^0,COLUMN(OFFSET($A$1,,,,LEN(String)))*ROW(OFFSET($A$1,,,LEN(String)))^0))*(COLUMN(OFFSET($A$1,,,,LEN(String)))+ROW(OFFSET($A$1,,,LEN(String)))-1),ROW(OFFSET($A$1,,,LEN(String)+1))-1)=1)*ISNUMBER(-MID(\"|\"&String&\"|\",ROW(OFFSET($A$1,,,LEN(String)+2)),1))}"}]
[null,null,null,null,null,null,null,{"$f":"SUBSTITUTE(_xlfn.FORMULATEXT(H127),MID(Formula5,FIND(\"=\",Formula5)+1,LEN(Formula5)-IF(LEFT(Formula5)=\"{\",1,0)-IF(RIGHT(Formula5)=\"}\",1,0)-1),Formula5_Label)","v":"{=(Formula5)*ISNUMBER(-MID(\"|\"&String&\"|\",ROW(OFFSET($A$1,,,LEN(String)+2)),1))}"}]
[null,null,null,null,null,null,"Position"]
[null,null,null,null,null,null,0,{"$f":"(FREQUENCY(ISNUMBER(-MID(String,ROW(OFFSET($A$1,,,LEN(String)))*COLUMN(OFFSET($A$1,,,,LEN(String)))^0,COLUMN(OFFSET($A$1,,,,LEN(String)))*ROW(OFFSET($A$1,,,LEN(String)))^0))*(COLUMN(OFFSET($A$1,,,,LEN(String)))+ROW(OFFSET($A$1,,,LEN(String)))-1),ROW(OFFSET($A$1,,,LEN(String)+1))-1)=1)*ISNUMBER(-MID(\"|\"&String&\"|\",ROW(OFFSET($A$1,,,LEN(String)+2)),1))","v":0}]
[null,null,null,null,null,{"$f":"MID(String,ROW(OFFSET($A$1,,,LEN(String))),1)","v":"J"},1,0]
[null,null,null,null,null,"e",2,0]
[null,null,null,null,null,"f",3,0]
[null,null,null,null,null,"f",4,0]
[null,null,null,null,null,"|",5,0]
[null,null,null,null,null,"W",6,0]
[null,null,null,null,null,"e",7,0]
[null,null,null,null,null,"i",8,0]
[null,null,null,null,null,"r",9,0]
[null,null,null,null,null,"|",10,0]
[null,null,null,null,null,"A",11,0]
[null,null,null,null,null,"g",12,0]
[null,null,null,null,null,"e",13,0]
[null,null,null,null,null,":",14,0]
[null,null,null,null,null,"|",15,0]
[null,null,null,null,null,"4",16,1]
[null,null,null,null,null,"3",17,0]
[null,null,null,null,null,"|",18,0]
[null,null,null,null,null,"D",19,0]
[null,null,null,null,null,null,">19",0]
[]
[null,null,null,null,null,null,"Formula7",{"$f":"_xlfn.FORMULATEXT(H152)","v":"{=IF((FREQUENCY(ISNUMBER(-MID(String,ROW(OFFSET($A$1,,,LEN(String)))*COLUMN(OFFSET($A$1,,,,LEN(String)))^0,COLUMN(OFFSET($A$1,,,,LEN(String)))*ROW(OFFSET($A$1,,,LEN(String)))^0))*(COLUMN(OFFSET($A$1,,,,LEN(String)))+ROW(OFFSET($A$1,,,LEN(String)))-1),ROW(OFFSET($A$1,,,LEN(String)+1))-1)=1)*ISNUMBER(-MID(\"|\"&String&\"|\",ROW(OFFSET($A$1,,,LEN(String)+2)),1))=1,ROW(OFFSET($A$1,,,LEN(String)+2))-1,FALSE)}"}]
[null,null,null,null,null,null,null,{"$f":"SUBSTITUTE(_xlfn.FORMULATEXT(H152),MID(Formula6,FIND(\"=\",Formula6)+1,LEN(Formula6)-IF(LEFT(Formula6)=\"{\",1,0)-IF(RIGHT(Formula6)=\"}\",1,0)-1),Formula6_Label)","v":"{=IF(Formula6=1,ROW(OFFSET($A$1,,,LEN(String)+2))-1,FALSE)}"}]
[null,null,null,null,null,null,"Position"]
[null,null,null,null,null,null,0,{"$f":"IF((FREQUENCY(ISNUMBER(-MID(String,ROW(OFFSET($A$1,,,LEN(String)))*COLUMN(OFFSET($A$1,,,,LEN(String)))^0,COLUMN(OFFSET($A$1,,,,LEN(String)))*ROW(OFFSET($A$1,,,LEN(String)))^0))*(COLUMN(OFFSET($A$1,,,,LEN(String)))+ROW(OFFSET($A$1,,,LEN(String)))-1),ROW(OFFSET($A$1,,,LEN(String)+1))-1)=1)*ISNUMBER(-MID(\"|\"&String&\"|\",ROW(OFFSET($A$1,,,LEN(String)+2)),1))=1,ROW(OFFSET($A$1,,,LEN(String)+2))-1,FALSE)","v":false}]
[null,null,null,null,null,{"$f":"MID(String,ROW(OFFSET($A$1,,,LEN(String))),1)","v":"J"},1,false]
[null,null,null,null,null,"e",2,false]
[null,null,null,null,null,"f",3,false]
[null,null,null,null,null,"f",4,false]
[null,null,null,null,null,"|",5,false]
[null,null,null,null,null,"W",6,false]
[null,null,null,null,null,"e",7,false]
[null,null,null,null,null,"i",8,false]
[null,null,null,null,null,"r",9,false]
[null,null,null,null,null,"|",10,false]
[null,null,null,null,null,"A",11,false]
[null,null,null,null,null,"g",12,false]
[null,null,null,null,null,"e",13,false]
[null,null,null,null,null,":",14,false]
[null,null,null,null,null,"|",15,false]
[null,null,null,null,null,"4",16,16]
[null,null,null,null,null,"3",17,false]
[null,null,null,null,null,"|",18,false]
[null,null,null,null,null,"D",19,false]
[null,null,null,null,null,null,">19",false]
[]
[]
[]
[null,null,null,null,null,null,"Formula8",{"$f":"_xlfn.FORMULATEXT(H180)","v":"{=SMALL(IF((FREQUENCY(ISNUMBER(-MID(String,ROW(OFFSET($A$1,,,LEN(String)))*COLUMN(OFFSET($A$1,,,,LEN(String)))^0,COLUMN(OFFSET($A$1,,,,LEN(String)))*ROW(OFFSET($A$1,,,LEN(String)))^0))*(COLUMN(OFFSET($A$1,,,,LEN(String)))+ROW(OFFSET($A$1,,,LEN(String)))-1),ROW(OFFSET($A$1,,,LEN(String)+1))-1)=1)*ISNUMBER(-MID(\"|\"&String&\"|\",ROW(OFFSET($A$1,,,LEN(String)+2)),1))=1,ROW(OFFSET($A$1,,,LEN(String)+2))-1,FALSE),ROW(OFFSET($A$1,,,LEN(String))))}"}]
[null,null,null,null,null,null,null,{"$f":"SUBSTITUTE(_xlfn.FORMULATEXT(H180),MID(Formula7,FIND(\"=\",Formula7)+1,LEN(Formula7)-IF(LEFT(Formula7)=\"{\",1,0)-IF(RIGHT(Formula7)=\"}\",1,0)-1),Formula7_Label)","v":"{=SMALL(Formula7,ROW(OFFSET($A$1,,,LEN(String))))}"}]
[]
[null,null,null,null,null,null,"Element","Position"]
[null,null,null,null,null,{"$f":"MID(String,ROW(OFFSET($A$1,,,LEN(String))),1)","v":"J"},1,{"$f":"SMALL(IF((FREQUENCY(ISNUMBER(-MID(String,ROW(OFFSET($A$1,,,LEN(String)))*COLUMN(OFFSET($A$1,,,,LEN(String)))^0,COLUMN(OFFSET($A$1,,,,LEN(String)))*ROW(OFFSET($A$1,,,LEN(String)))^0))*(COLUMN(OFFSET($A$1,,,,LEN(String)))+ROW(OFFSET($A$1,,,LEN(String)))-1),ROW(OFFSET($A$1,,,LEN(String)+1))-1)=1)*ISNUMBER(-MID(\"|\"&String&\"|\",ROW(OFFSET($A$1,,,LEN(String)+2)),1))=1,ROW(OFFSET($A$1,,,LEN(String)+2))-1,FALSE),ROW(OFFSET($A$1,,,LEN(String))))","v":16}]
[null,null,null,null,null,"e",2,24]
[null,null,null,null,null,"f",3,40]
[null,null,null,null,null,"f",4,61]
[null,null,null,null,null,"|",5,{"$error":"#NUM!"}]
[null,null,null,null,null,"W",6,{"$error":"#NUM!"}]
[null,null,null,null,null,"e",7,{"$error":"#NUM!"}]
[null,null,null,null,null,"i",8,{"$error":"#NUM!"}]
[null,null,null,null,null,"r",9,{"$error":"#NUM!"}]
[null,null,null,null,null,"|",10,{"$error":"#NUM!"}]
[null,null,null,null,null,"A",11,{"$error":"#NUM!"}]
[null,null,null,null,null,"g",12,{"$error":"#NUM!"}]
[null,null,null,null,null,"e",13,{"$error":"#NUM!"}]
[null,null,null,null,null,":",14,{"$error":"#NUM!"}]
[null,null,null,null,null,"|",15,{"$error":"#NUM!"}]
[null,null,null,null,null,"4",16,{"$error":"#NUM!"}]
[null,null,null,null,null,"3",17,{"$error":"#NUM!"}]
[null,null,null,null,null,"|",18,{"$error":"#NUM!"}]
[null,null,null,null,null,"D",19,{"$error":"#NUM!"}]
[]
[null,null,null,null,null,null,"Formula3b",{"$f":"_xlfn.FORMULATEXT(H203)","v":"{=ISNUMBER(-MID(String&\"|\",ROW(OFFSET($A$1,,,LEN(String)))*COLUMN(OFFSET($A$1,,,,LEN(String)))^0,COLUMN(OFFSET($A$1,,,,LEN(String)))*ROW(OFFSET($A$1,,,LEN(String)))^0))*(LEN(String)+1-ROW(OFFSET($A$1,,,LEN(String))))}"}]
[null,null,null,null,null,null,null,{"$f":"SUBSTITUTE(_xlfn.FORMULATEXT(H203),MID(Formula2,FIND(\"=\",Formula2)+1,LEN(Formula2)-IF(LEFT(Formula2)=\"{\",1,0)-IF(RIGHT(Formula2)=\"}\",1,0)-1),Formula2_Label)","v":"{=ISNUMBER(-MID(String&\"|\",ROW(OFFSET($A$1,,,LEN(String)))*COLUMN(OFFSET($A$1,,,,LEN(String)))^0,COLUMN(OFFSET($A$1,,,,LEN(String)))*ROW(OFFSET($A$1,,,LEN(String)))^0))*(LEN(String)+1-ROW(OFFSET($A$1,,,LEN(String))))}"}]
[null,null,null,null,null,null,"Substring Length >>  ",1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19]
[null,null,null,null,null,{"$f":"MID(String,ROW(OFFSET($A$1,,,LEN(String))),1)","v":"J"},1,{"$f":"ISNUMBER(-MID(String&\"|\",ROW(OFFSET($A$1,,,LEN(String)))*COLUMN(OFFSET($A$1,,,,LEN(String)))^0,COLUMN(OFFSET($A$1,,,,LEN(String)))*ROW(OFFSET($A$1,,,LEN(String)))^0))*(LEN(String)+1-ROW(OFFSET($A$1,,,LEN(String))))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,"e",2,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,"f",3,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,"f",4,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,"|",5,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,"W",6,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,"e",7,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,"i",8,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,"r",9,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,"|",10,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,"A",11,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,"g",12,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,"e",13,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,":",14,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,"|",15,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,"4",16,49,49,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,"3",17,48,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,"|",18,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,"D",19,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,null,null,null,null,null,"Formula4b",{"$f":"_xlfn.FORMULATEXT(H226)","v":"{=FREQUENCY(ISNUMBER(-MID(String&\"|\",ROW(OFFSET($A$1,,,LEN(String)))*COLUMN(OFFSET($A$1,,,,LEN(String)))^0,COLUMN(OFFSET($A$1,,,,LEN(String)))*ROW(OFFSET($A$1,,,LEN(String)))^0))*(LEN(String)+1-ROW(OFFSET($A$1,,,LEN(String)))),MOD(LEN(String)+2-ROW(OFFSET($A$1,,,LEN(String)+1)),LEN(String)+1))}"}]
[null,null,null,null,null,null,null,{"$f":"SUBSTITUTE(_xlfn.FORMULATEXT(H226),MID(Formula3b,FIND(\"=\",Formula3b)+1,LEN(Formula3b)-IF(LEFT(Formula3b)=\"{\",1,0)-IF(RIGHT(Formula3b)=\"}\",1,0)-1),Formula3b_Label)","v":"{=FREQUENCY(Formula3b,MOD(LEN(String)+2-ROW(OFFSET($A$1,,,LEN(String)+1)),LEN(String)+1))}"}]
[null,null,null,null,null,null,"Position"]
[null,null,null,null,null,null,0,{"$f":"FREQUENCY(ISNUMBER(-MID(String&\"|\",ROW(OFFSET($A$1,,,LEN(String)))*COLUMN(OFFSET($A$1,,,,LEN(String)))^0,COLUMN(OFFSET($A$1,,,,LEN(String)))*ROW(OFFSET($A$1,,,LEN(String)))^0))*(LEN(String)+1-ROW(OFFSET($A$1,,,LEN(String)))),MOD(LEN(String)+2-ROW(OFFSET($A$1,,,LEN(String)+1)),LEN(String)+1))","v":4027}]
[null,null,null,null,null,{"$f":"MID(String,ROW(OFFSET($A$1,,,LEN(String))),1)","v":"J"},1,0]
[null,null,null,null,null,"e",2,0]
[null,null,null,null,null,"f",3,0]
[null,null,null,null,null,"f",4,0]
[null,null,null,null,null,"|",5,0]
[null,null,null,null,null,"W",6,0]
[null,null,null,null,null,"e",7,0]
[null,null,null,null,null,"i",8,0]
[null,null,null,null,null,"r",9,0]
[null,null,null,null,null,"|",10,0]
[null,null,null,null,null,"A",11,0]
[null,null,null,null,null,"g",12,0]
[null,null,null,null,null,"e",13,0]
[null,null,null,null,null,":",14,0]
[null,null,null,null,null,"|",15,0]
[null,null,null,null,null,"4",16,2]
[null,null,null,null,null,"3",17,1]
[null,null,null,null,null,"|",18,0]
[null,null,null,null,null,"D",19,0]
[null,null,null,null,null,null,">19",0]
[]
[null,null,null,null,null,null,"Formula5b",{"$f":"_xlfn.FORMULATEXT(H251)","v":"{=FREQUENCY(ISNUMBER(-MID(String&\"|\",ROW(OFFSET($A$1,,,LEN(String)))*COLUMN(OFFSET($A$1,,,,LEN(String)))^0,COLUMN(OFFSET($A$1,,,,LEN(String)))*ROW(OFFSET($A$1,,,LEN(String)))^0))*(LEN(String)+1-ROW(OFFSET($A$1,,,LEN(String)))),MOD(LEN(String)+2-ROW(OFFSET($A$1,,,LEN(String)+1)),LEN(String)+1))=1}"}]
[null,null,null,null,null,null,null,{"$f":"SUBSTITUTE(_xlfn.FORMULATEXT(H251),MID(Formula4b,FIND(\"=\",Formula4b)+1,LEN(Formula4b)-IF(LEFT(Formula4b)=\"{\",1,0)-IF(RIGHT(Formula4b)=\"}\",1,0)-1),Formula4b_Label)","v":"{=Formula4b=1}"}]
[null,null,null,null,null,null,"Position"]
[null,null,null,null,null,null,0,{"$f":"FREQUENCY(ISNUMBER(-MID(String&\"|\",ROW(OFFSET($A$1,,,LEN(String)))*COLUMN(OFFSET($A$1,,,,LEN(String)))^0,COLUMN(OFFSET($A$1,,,,LEN(String)))*ROW(OFFSET($A$1,,,LEN(String)))^0))*(LEN(String)+1-ROW(OFFSET($A$1,,,LEN(String)))),MOD(LEN(String)+2-ROW(OFFSET($A$1,,,LEN(String)+1)),LEN(String)+1))=1","v":false}]
[null,null,null,null,null,{"$f":"MID(String,ROW(OFFSET($A$1,,,LEN(String))),1)","v":"J"},1,false]
[null,null,null,null,null,"e",2,false]
[null,null,null,null,null,"f",3,false]
[null,null,null,null,null,"f",4,false]
[null,null,null,null,null,"|",5,false]
[null,null,null,null,null,"W",6,false]
[null,null,null,null,null,"e",7,false]
[null,null,null,null,null,"i",8,false]
[null,null,null,null,null,"r",9,false]
[null,null,null,null,null,"|",10,false]
[null,null,null,null,null,"A",11,false]
[null,null,null,null,null,"g",12,false]
[null,null,null,null,null,"e",13,false]
[null,null,null,null,null,":",14,false]
[null,null,null,null,null,"|",15,false]
[null,null,null,null,null,"4",16,false]
[null,null,null,null,null,"3",17,true]
[null,null,null,null,null,"|",18,false]
[null,null,null,null,null,"D",19,false]
[null,null,null,null,null,null,">19",false]
[]
[null,null,null,null,null,null,"Formula6b",{"$f":"_xlfn.FORMULATEXT(H276)","v":"{=(FREQUENCY(ISNUMBER(-MID(String&\"|\",ROW(OFFSET($A$1,,,LEN(String)))*COLUMN(OFFSET($A$1,,,,LEN(String)))^0,COLUMN(OFFSET($A$1,,,,LEN(String)))*ROW(OFFSET($A$1,,,LEN(String)))^0))*(LEN(String)+1-ROW(OFFSET($A$1,,,LEN(String)))),MOD(LEN(String)+2-ROW(OFFSET($A$1,,,LEN(String)+1)),LEN(String)+1))=1)*ISNUMBER(-MID(\"|\"&String,ROW(OFFSET($A$1,,,LEN(String)+2)),1))}"}]
[null,null,null,null,null,null,null,{"$f":"SUBSTITUTE(_xlfn.FORMULATEXT(H276),MID(Formula5b,FIND(\"=\",Formula5b)+1,LEN(Formula5b)-IF(LEFT(Formula5b)=\"{\",1,0)-IF(RIGHT(Formula5b)=\"}\",1,0)-1),Formula5b_Label)","v":"{=(Formula5b)*ISNUMBER(-MID(\"|\"&String,ROW(OFFSET($A$1,,,LEN(String)+2)),1))}"}]
[null,null,null,null,null,null,"Position"]
[null,null,null,null,null,null,0,{"$f":"(FREQUENCY(ISNUMBER(-MID(String&\"|\",ROW(OFFSET($A$1,,,LEN(String)))*COLUMN(OFFSET($A$1,,,,LEN(String)))^0,COLUMN(OFFSET($A$1,,,,LEN(String)))*ROW(OFFSET($A$1,,,LEN(String)))^0))*(LEN(String)+1-ROW(OFFSET($A$1,,,LEN(String)))),MOD(LEN(String)+2-ROW(OFFSET($A$1,,,LEN(String)+1)),LEN(String)+1))=1)*ISNUMBER(-MID(\"|\"&String,ROW(OFFSET($A$1,,,LEN(String)+2)),1))","v":0}]
[null,null,null,null,null,{"$f":"MID(String,ROW(OFFSET($A$1,,,LEN(String))),1)","v":"J"},1,0]
[null,null,null,null,null,"e",2,0]
[null,null,null,null,null,"f",3,0]
[null,null,null,null,null,"f",4,0]
[null,null,null,null,null,"|",5,0]
[null,null,null,null,null,"W",6,0]
[null,null,null,null,null,"e",7,0]
[null,null,null,null,null,"i",8,0]
[null,null,null,null,null,"r",9,0]
[null,null,null,null,null,"|",10,0]
[null,null,null,null,null,"A",11,0]
[null,null,null,null,null,"g",12,0]
[null,null,null,null,null,"e",13,0]
[null,null,null,null,null,":",14,0]
[null,null,null,null,null,"|",15,0]
[null,null,null,null,null,"4",16,0]
[null,null,null,null,null,"3",17,1]
[null,null,null,null,null,"|",18,0]
[null,null,null,null,null,"D",19,0]
[null,null,null,null,null,null,">19",0]
[]
[null,null,null,null,null,null,"Formula7b",{"$f":"_xlfn.FORMULATEXT(H301)","v":"{=IF((FREQUENCY(ISNUMBER(-MID(String&\"|\",ROW(OFFSET($A$1,,,LEN(String)))*COLUMN(OFFSET($A$1,,,,LEN(String)))^0,COLUMN(OFFSET($A$1,,,,LEN(String)))*ROW(OFFSET($A$1,,,LEN(String)))^0))*(LEN(String)+1-ROW(OFFSET($A$1,,,LEN(String)))),MOD(LEN(String)+2-ROW(OFFSET($A$1,,,LEN(String)+1)),LEN(String)+1))=1)*ISNUMBER(-MID(\"|\"&String,ROW(OFFSET($A$1,,,LEN(String)+2)),1))=1,ROW(OFFSET($A$1,,,LEN(String)+2))-1,FALSE)}"}]
[null,null,null,null,null,null,null,{"$f":"SUBSTITUTE(_xlfn.FORMULATEXT(H301),MID(Formula6b,FIND(\"=\",Formula6b)+1,LEN(Formula6b)-IF(LEFT(Formula6b)=\"{\",1,0)-IF(RIGHT(Formula6b)=\"}\",1,0)-1),Formula6b_Label)","v":"{=IF(Formula6b=1,ROW(OFFSET($A$1,,,LEN(String)+2))-1,FALSE)}"}]
[null,null,null,null,null,null,"Element Start"]
[null,null,null,null,null,null,0,{"$f":"IF((FREQUENCY(ISNUMBER(-MID(String&\"|\",ROW(OFFSET($A$1,,,LEN(String)))*COLUMN(OFFSET($A$1,,,,LEN(String)))^0,COLUMN(OFFSET($A$1,,,,LEN(String)))*ROW(OFFSET($A$1,,,LEN(String)))^0))*(LEN(String)+1-ROW(OFFSET($A$1,,,LEN(String)))),MOD(LEN(String)+2-ROW(OFFSET($A$1,,,LEN(String)+1)),LEN(String)+1))=1)*ISNUMBER(-MID(\"|\"&String,ROW(OFFSET($A$1,,,LEN(String)+2)),1))=1,ROW(OFFSET($A$1,,,LEN(String)+2))-1,FALSE)","v":false}]
[null,null,null,null,null,{"$f":"MID(String,ROW(OFFSET($A$1,,,LEN(String))),1)","v":"J"},1,false]
[null,null,null,null,null,"e",2,false]
[null,null,null,null,null,"f",3,false]
[null,null,null,null,null,"f",4,false]
[null,null,null,null,null,"|",5,false]
[null,null,null,null,null,"W",6,false]
[null,null,null,null,null,"e",7,false]
[null,null,null,null,null,"i",8,false]
[null,null,null,null,null,"r",9,false]
[null,null,null,null,null,"|",10,false]
[null,null,null,null,null,"A",11,false]
[null,null,null,null,null,"g",12,false]
[null,null,null,null,null,"e",13,false]
[null,null,null,null,null,":",14,false]
[null,null,null,null,null,"|",15,false]
[null,null,null,null,null,"4",16,false]
[null,null,null,null,null,"3",17,17]
[null,null,null,null,null,"|",18,false]
[null,null,null,null,null,"D",19,false]
[null,null,null,null,null,null,">19",false]
[]
[null,null,{"$f":"String","v":"Jeff|Weir|Age:|43|DOB:|25/4/71|Salary:|100000.00|StartTime:|8:30"},null,null,null,"Formula8b",{"$f":"_xlfn.FORMULATEXT(H327)","v":"{=SMALL(IF((FREQUENCY(ISNUMBER(-MID(String&\"|\",ROW(OFFSET($A$1,,,LEN(String)))*COLUMN(OFFSET($A$1,,,,LEN(String)))^0,COLUMN(OFFSET($A$1,,,,LEN(String)))*ROW(OFFSET($A$1,,,LEN(String)))^0))*(LEN(String)+1-ROW(OFFSET($A$1,,,LEN(String)))),MOD(LEN(String)+2-ROW(OFFSET($A$1,,,LEN(String)+1)),LEN(String)+1))=1)*ISNUMBER(-MID(\"|\"&String,ROW(OFFSET($A$1,,,LEN(String)+2)),1))=1,ROW(OFFSET($A$1,,,LEN(String)+2))-1,FALSE),ROW(OFFSET($A$1,,,LEN(String))))}"}]
[null,null,null,null,null,null,null,{"$f":"SUBSTITUTE(_xlfn.FORMULATEXT(H327),MID(Formula7b,FIND(\"=\",Formula7b)+1,LEN(Formula7b)-IF(LEFT(Formula7b)=\"{\",1,0)-IF(RIGHT(Formula7b)=\"}\",1,0)-1),Formula7b_Label)","v":"{=SMALL(Formula7b,ROW(OFFSET($A$1,,,LEN(String))))}"}]
[]
[null,null,null,null,null,null,"Element End","Position"]
[null,null,null,null,null,{"$f":"MID(String,ROW(OFFSET($A$1,,,LEN(String))),1)","v":"J"},1,{"$f":"SMALL(IF((FREQUENCY(ISNUMBER(-MID(String&\"|\",ROW(OFFSET($A$1,,,LEN(String)))*COLUMN(OFFSET($A$1,,,,LEN(String)))^0,COLUMN(OFFSET($A$1,,,,LEN(String)))*ROW(OFFSET($A$1,,,LEN(String)))^0))*(LEN(String)+1-ROW(OFFSET($A$1,,,LEN(String)))),MOD(LEN(String)+2-ROW(OFFSET($A$1,,,LEN(String)+1)),LEN(String)+1))=1)*ISNUMBER(-MID(\"|\"&String,ROW(OFFSET($A$1,,,LEN(String)+2)),1))=1,ROW(OFFSET($A$1,,,LEN(String)+2))-1,FALSE),ROW(OFFSET($A$1,,,LEN(String))))","v":17}]
[null,null,null,null,null,"e",2,30]
[null,null,null,null,null,"f",3,48]
[null,null,null,null,null,"f",4,64]
[null,null,null,null,null,"|",5,{"$error":"#NUM!"}]
[null,null,null,null,null,"W",6,{"$error":"#NUM!"}]
[null,null,null,null,null,"e",7,{"$error":"#NUM!"}]
[null,null,null,null,null,"i",8,{"$error":"#NUM!"}]
[null,null,null,null,null,"r",9,{"$error":"#NUM!"}]
[null,null,null,null,null,"|",10,{"$error":"#NUM!"}]
[null,null,null,null,null,"A",11,{"$error":"#NUM!"}]
[null,null,null,null,null,"g",12,{"$error":"#NUM!"}]
[null,null,null,null,null,"e",13,{"$error":"#NUM!"}]
[null,null,null,null,null,":",14,{"$error":"#NUM!"}]
[null,null,null,null,null,"|",15,{"$error":"#NUM!"}]
[null,null,null,null,null,"4",16,{"$error":"#NUM!"}]
[null,null,null,null,null,"3",17,{"$error":"#NUM!"}]
[null,null,null,null,null,"|",18,{"$error":"#NUM!"}]
[null,null,null,null,null,"D",19,{"$error":"#NUM!"}]
[]
[]
[null,null,null,null,null,{"$f":"Formula8_Label","v":"Formula8"},{"$f":"Formula8","v":"{=SMALL(IF((FREQUENCY(ISNUMBER(-MID(String,ROW(OFFSET($A$1,,,LEN(String)))*COLUMN(OFFSET($A$1,,,,LEN(String)))^0,COLUMN(OFFSET($A$1,,,,LEN(String)))*ROW(OFFSET($A$1,,,LEN(String)))^0))*(COLUMN(OFFSET($A$1,,,,LEN(String)))+ROW(OFFSET($A$1,,,LEN(String)))-1),ROW(OFFSET($A$1,,,LEN(String)+1))-1)=1)*ISNUMBER(-MID(\"|\"&String&\"|\",ROW(OFFSET($A$1,,,LEN(String)+2)),1))=1,ROW(OFFSET($A$1,,,LEN(String)+2))-1,FALSE),ROW(OFFSET($A$1,,,LEN(String))))}"}]
[null,null,null,null,null,{"$f":"Formula8b_Label","v":"Formula8b"},{"$f":"Formula8b","v":"{=SMALL(IF((FREQUENCY(ISNUMBER(-MID(String&\"|\",ROW(OFFSET($A$1,,,LEN(String)))*COLUMN(OFFSET($A$1,,,,LEN(String)))^0,COLUMN(OFFSET($A$1,,,,LEN(String)))*ROW(OFFSET($A$1,,,LEN(String)))^0))*(LEN(String)+1-ROW(OFFSET($A$1,,,LEN(String)))),MOD(LEN(String)+2-ROW(OFFSET($A$1,,,LEN(String)+1)),LEN(String)+1))=1)*ISNUMBER(-MID(\"|\"&String,ROW(OFFSET($A$1,,,LEN(String)+2)),1))=1,ROW(OFFSET($A$1,,,LEN(String)+2))-1,FALSE),ROW(OFFSET($A$1,,,LEN(String))))}"}]
[null,null,null,null,null,"Final Formula",{"$f":"_xlfn.FORMULATEXT(G354)","v":"{=MID(String,SMALL(IF((FREQUENCY(ISNUMBER(-MID(String,ROW(OFFSET($A$1,,,LEN(String)))*COLUMN(OFFSET($A$1,,,,LEN(String)))^0,COLUMN(OFFSET($A$1,,,,LEN(String)))*ROW(OFFSET($A$1,,,LEN(String)))^0))*(COLUMN(OFFSET($A$1,,,,LEN(String)))+ROW(OFFSET($A$1,,,LEN(String)))-1),ROW(OFFSET($A$1,,,LEN(String)+1))-1)=1)*ISNUMBER(-MID(\"|\"&String&\"|\",ROW(OFFSET($A$1,,,LEN(String)+2)),1))=1,ROW(OFFSET($A$1,,,LEN(String)+2))-1,FALSE),ROW(OFFSET($A$1,,,LEN(String)))),SMALL(IF((FREQUENCY(ISNUMBER(-MID(String&\"|\",ROW(OFFSET($A$1,,,LEN(String)))*COLUMN(OFFSET($A$1,,,,LEN(String)))^0,COLUMN(OFFSET($A$1,,,,LEN(String)))*ROW(OFFSET($A$1,,,LEN(String)))^0))*(LEN(String)+1-ROW(OFFSET($A$1,,,LEN(String)))),MOD(LEN(String)+2-ROW(OFFSET($A$1,,,LEN(String)+1)),LEN(String)+1))=1)*ISNUMBER(-MID(\"|\"&String,ROW(OFFSET($A$1,,,LEN(String)+2)),1))=1,ROW(OFFSET($A$1,,,LEN(String)+2))-1,FALSE),ROW(OFFSET($A$1,,,LEN(String))))-SMALL(IF((FREQUENCY(ISNUMBER(-MID(String,ROW(OFFSET($A$1,,,LEN(String)))*COLUMN(OFFSET($A$1,,,,LEN(String)))^0,COLUMN(OFFSET($A$1,,,,LEN(String)))*ROW(OFFSET($A$1,,,LEN(String)))^0))*(COLUMN(OFFSET($A$1,,,,LEN(String)))+ROW(OFFSET($A$1,,,LEN(String)))-1),ROW(OFFSET($A$1,,,LEN(String)+1))-1)=1)*ISNUMBER(-MID(\"|\"&String&\"|\",ROW(OFFSET($A$1,,,LEN(String)+2)),1))=1,ROW(OFFSET($A$1,,,LEN(String)+2))-1,FALSE),ROW(OFFSET($A$1,,,LEN(String))))+1)}"}]
[null,null,null,null,null,null,"=MID(String,Formula8,Formula9-Formula8+1)"]
[]
[null,null,null,null,null,null,"Final Formula Result:"]
[null,null,null,null,null,null,{"$f":"MID(String,SMALL(IF((FREQUENCY(ISNUMBER(-MID(String,ROW(OFFSET($A$1,,,LEN(String)))*COLUMN(OFFSET($A$1,,,,LEN(String)))^0,COLUMN(OFFSET($A$1,,,,LEN(String)))*ROW(OFFSET($A$1,,,LEN(String)))^0))*(COLUMN(OFFSET($A$1,,,,LEN(String)))+ROW(OFFSET($A$1,,,LEN(String)))-1),ROW(OFFSET($A$1,,,LEN(String)+1))-1)=1)*ISNUMBER(-MID(\"|\"&String&\"|\",ROW(OFFSET($A$1,,,LEN(String)+2)),1))=1,ROW(OFFSET($A$1,,,LEN(String)+2))-1,FALSE),ROW(OFFSET($A$1,,,LEN(String)))),SMALL(IF((FREQUENCY(ISNUMBER(-MID(String&\"|\",ROW(OFFSET($A$1,,,LEN(String)))*COLUMN(OFFSET($A$1,,,,LEN(String)))^0,COLUMN(OFFSET($A$1,,,,LEN(String)))*ROW(OFFSET($A$1,,,LEN(String)))^0))*(LEN(String)+1-ROW(OFFSET($A$1,,,LEN(String)))),MOD(LEN(String)+2-ROW(OFFSET($A$1,,,LEN(String)+1)),LEN(String)+1))=1)*ISNUMBER(-MID(\"|\"&String,ROW(OFFSET($A$1,,,LEN(String)+2)),1))=1,ROW(OFFSET($A$1,,,LEN(String)+2))-1,FALSE),ROW(OFFSET($A$1,,,LEN(String))))-SMALL(IF((FREQUENCY(ISNUMBER(-MID(String,ROW(OFFSET($A$1,,,LEN(String)))*COLUMN(OFFSET($A$1,,,,LEN(String)))^0,COLUMN(OFFSET($A$1,,,,LEN(String)))*ROW(OFFSET($A$1,,,LEN(String)))^0))*(COLUMN(OFFSET($A$1,,,,LEN(String)))+ROW(OFFSET($A$1,,,LEN(String)))-1),ROW(OFFSET($A$1,,,LEN(String)+1))-1)=1)*ISNUMBER(-MID(\"|\"&String&\"|\",ROW(OFFSET($A$1,,,LEN(String)+2)),1))=1,ROW(OFFSET($A$1,,,LEN(String)+2))-1,FALSE),ROW(OFFSET($A$1,,,LEN(String))))+1)","v":"43"}]
[null,null,null,null,null,null,"25/4/71"]
[null,null,null,null,null,null,"100000.00"]
[null,null,null,null,null,null,"8:30"]
[null,null,null,null,null,null,{"$error":"#NUM!"}]
[null,null,null,null,null,null,{"$error":"#NUM!"}]
[null,null,null,null,null,null,{"$error":"#NUM!"}]
[null,null,null,null,null,null,{"$error":"#NUM!"}]
[null,null,null,null,null,null,{"$error":"#NUM!"}]
[null,null,null,null,null,null,{"$error":"#NUM!"}]
[null,null,null,null,null,null,{"$error":"#NUM!"}]
[null,null,null,null,null,null,{"$error":"#NUM!"}]
[null,null,null,null,null,null,{"$error":"#NUM!"}]