{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Flash Fill","Using MIN and FIND","Text to Columns","Using SEARCH","Using Macro"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":0,"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":"Flash Fill","index":0,"n_rows":13,"n_cols":4,"rows_kept":13,"cut":false,"hidden":false,"merged":[[0,0,0,4]]}
["Student Record of Saint Xaviers School"]
[]
[null,"Combined Data","Student Name","Student ID"]
[null,"Steve Morris101","Steve Morris",101]
[null,"Peter Dulbarg123","Peter Dulbarg",123]
[null,"Usman Malik287","Usman Malik",287]
[null,"Christina Moor332","Christina Moor",332]
[null,"Robert Millosky313","Robert Millosky",313]
[null,"Benjamin Hick250","Benjamin Hick",250]
[null,"Ross Hales212","Ross Hales",212]
[null,"Ben Ducket223","Ben Ducket",223]
[null,"Richard Hawckly212","Richard Hawckly",212]
[null,"Natalia Trott209","Natalia Trott",209]

{"sheet":"Using MIN and FIND","index":1,"n_rows":14,"n_cols":8,"rows_kept":14,"cut":false,"hidden":false,"merged":[[0,0,0,4]]}
["Student Record of Saint Xaviers School"]
[]
[null,"Combined Data","Student Name","Student ID","Position where Number Starts"]
[null,"Steve Morris101",{"$f":"LEFT(B4,MIN(FIND({0,1,2,3,4,5,6,7,8,9},B4&\"0123456789\"))-1)","v":"Steve Morris"},{"$f":"RIGHT(B4,LEN(B4)-MIN(FIND({0,1,2,3,4,5,6,7,8,9},B4&\"0123456789\"))+1)","v":"101"},{"$f":"MIN(FIND({0,1,2,3,4,5,6,7,8,9},B4&\"0123456789\"))","v":13}]
[null,"Peter Dulbarg123",{"$f":"LEFT(B5,MIN(FIND({0,1,2,3,4,5,6,7,8,9},B5&\"0123456789\"))-1)","v":"Peter Dulbarg"},{"$f":"RIGHT(B5,LEN(B5)-MIN(FIND({0,1,2,3,4,5,6,7,8,9},B5&\"0123456789\"))+1)","v":"123"}]
[null,"Usman Malik287",{"$f":"LEFT(B6,MIN(FIND({0,1,2,3,4,5,6,7,8,9},B6&\"0123456789\"))-1)","v":"Usman Malik"},{"$f":"RIGHT(B6,LEN(B6)-MIN(FIND({0,1,2,3,4,5,6,7,8,9},B6&\"0123456789\"))+1)","v":"287"}]
[null,"Christina Moor332",{"$f":"LEFT(B7,MIN(FIND({0,1,2,3,4,5,6,7,8,9},B7&\"0123456789\"))-1)","v":"Christina Moor"},{"$f":"RIGHT(B7,LEN(B7)-MIN(FIND({0,1,2,3,4,5,6,7,8,9},B7&\"0123456789\"))+1)","v":"332"}]
[null,"Robert Millosky313",{"$f":"LEFT(B8,MIN(FIND({0,1,2,3,4,5,6,7,8,9},B8&\"0123456789\"))-1)","v":"Robert Millosky"},{"$f":"RIGHT(B8,LEN(B8)-MIN(FIND({0,1,2,3,4,5,6,7,8,9},B8&\"0123456789\"))+1)","v":"313"}]
[null,"Benjamin Hick250",{"$f":"LEFT(B9,MIN(FIND({0,1,2,3,4,5,6,7,8,9},B9&\"0123456789\"))-1)","v":"Benjamin Hick"},{"$f":"RIGHT(B9,LEN(B9)-MIN(FIND({0,1,2,3,4,5,6,7,8,9},B9&\"0123456789\"))+1)","v":"250"}]
[null,"Ross Hales212",{"$f":"LEFT(B10,MIN(FIND({0,1,2,3,4,5,6,7,8,9},B10&\"0123456789\"))-1)","v":"Ross Hales"},{"$f":"RIGHT(B10,LEN(B10)-MIN(FIND({0,1,2,3,4,5,6,7,8,9},B10&\"0123456789\"))+1)","v":"212"}]
[null,"Ben Ducket223",{"$f":"LEFT(B11,MIN(FIND({0,1,2,3,4,5,6,7,8,9},B11&\"0123456789\"))-1)","v":"Ben Ducket"},{"$f":"RIGHT(B11,LEN(B11)-MIN(FIND({0,1,2,3,4,5,6,7,8,9},B11&\"0123456789\"))+1)","v":"223"}]
[null,"Richard Hawckly212",{"$f":"LEFT(B12,MIN(FIND({0,1,2,3,4,5,6,7,8,9},B12&\"0123456789\"))-1)","v":"Richard Hawckly"},{"$f":"RIGHT(B12,LEN(B12)-MIN(FIND({0,1,2,3,4,5,6,7,8,9},B12&\"0123456789\"))+1)","v":"212"}]
[null,"Natalia Trott209",{"$f":"LEFT(B13,MIN(FIND({0,1,2,3,4,5,6,7,8,9},B13&\"0123456789\"))-1)","v":"Natalia Trott"},{"$f":"RIGHT(B13,LEN(B13)-MIN(FIND({0,1,2,3,4,5,6,7,8,9},B13&\"0123456789\"))+1)","v":"209"}]
[null,null,null,null,null,null,null,{"$f":"SEARCH(\"a\",\"anahita\")","v":1}]

{"sheet":"Text to Columns","index":2,"n_rows":13,"n_cols":4,"rows_kept":13,"cut":false,"hidden":false,"merged":[[0,0,0,4]]}
["Student Record of Saint Xaviers School"]
[]
[null,"Combined Data","Student Name","Student ID"]
[null,"Steve Morris,101","Steve Morris",101]
[null,"Peter Dulbarg,123","Peter Dulbarg",123]
[null,"Usman Malik,287","Usman Malik",287]
[null,"Christina Moor,332","Christina Moor",332]
[null,"Robert Millosky,313","Robert Millosky",313]
[null,"Benjamin Hick,250","Benjamin Hick",250]
[null,"Ross Hales,212","Ross Hales",212]
[null,"Ben Ducket,223","Ben Ducket",223]
[null,"Richard Hawckly,212","Richard Hawckly",212]
[null,"Natalia Trott,209","Natalia Trott",209]

{"sheet":"Using SEARCH","index":3,"n_rows":13,"n_cols":4,"rows_kept":13,"cut":false,"hidden":false,"merged":[[0,0,0,4]]}
["Student Record of Saint Xaviers School"]
[]
[null,"Combined Data","Student Name","Student ID"]
[null,"Steve Morris,101",{"$f":"LEFT(B4,SEARCH(\",\",B4)-1)","v":"Steve Morris"},{"$f":"RIGHT(B4,LEN(B4)-SEARCH(\",\",B4))","v":"101"}]
[null,"Peter Dulbarg,123",{"$f":"LEFT(B5,SEARCH(\",\",B5)-1)","v":"Peter Dulbarg"},{"$f":"RIGHT(B5,LEN(B5)-SEARCH(\",\",B5))","v":"123"}]
[null,"Usman Malik,287","Usman Malik","287"]
[null,"Christina Moor,332","Christina Moor","332"]
[null,"Robert Millosky,313","Robert Millosky","313"]
[null,"Benjamin Hick,250","Benjamin Hick","250"]
[null,"Ross Hales,212","Ross Hales","212"]
[null,"Ben Ducket,223","Ben Ducket","223"]
[null,"Richard Hawckly,212","Richard Hawckly","212"]
[null,"Natalia Trott,209","Natalia Trott","209"]

{"sheet":"Using Macro","index":4,"n_rows":13,"n_cols":4,"rows_kept":13,"cut":false,"hidden":false,"merged":[[0,0,0,4]]}
["Student Record of Saint Xaviers School"]
[]
[null,"Combined Data","Student Name","Student ID"]
[null,"Steve10 M1orris",{"$f":"SplitText(B4,FALSE)","v":"Steve Morris"},{"$f":"SplitText(B4,TRUE)","v":"101"}]
[null,"Peter Du12lba3rg",{"$f":"SplitText(B5,FALSE)","v":"Peter Dulbarg"},{"$f":"SplitText(B5,TRUE)","v":"123"}]
[null,"Usman M28ali7k","Usman Malik","287"]
[null,"Chris3tina M3o2or","Christina Moor","332"]
[null,"Robert 31M3illosky","Robert Millosky","313"]
[null,"Benjamin 250Hick","Benjamin Hick","250"]
[null,"Ross H212ales","Ross Hales","212"]
[null,"Be223n Ducket","Ben Ducket","223"]
[null,"Richard H2aw1ck2ly","Richard Hawckly","212"]
[null,"Natalia20 Trott9","Natalia Trott","209"]