{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Contents","Find","First Name and Last name","Find nth Character","Find Vs Search","Find middle Part"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":1,"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":"Contents","index":0,"n_rows":47,"n_cols":6,"rows_kept":47,"cut":false,"hidden":false,"merged":[]}
["FIND Function"]
[null,"automateexcel.com/functions/find-formula-excel"]
[]
[null,"Table of Contents",null,null,null,"Other Resources"]
[null,"Find",null,null,null,"Excel Formulas w/Examples"]
[null,"First Name and Last name",null,null,null,"Excel Boot Camp - Learn Excel inside Excel"]
[null,"Find nth Character",null,null,null,"Excel Functions & Formulas Tutorial"]
[null,"Find Vs Search"]
[null,"Find middle Part"]
[]
[]
[]
[null,"Excel Boot Camp"]
[null,"  Learn Excel Inside Excel"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"           Learn Excel inside Excel with our Interactive Tutorial"]
[null,"           Automatically Graded Exercises"]
[null,"           Shortcuts & Best Practices \"Work Smarter, not Harder\""]
[]
[]
[]
[]
[]
[]
[]
[null,"Course Contents"]

{"sheet":"Find","index":1,"n_rows":17,"n_cols":6,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
["Content!A1"]
[null,"FIND",null,"=FIND (find_text, within_text, [start_num])"]
[]
[null,"The Excel FIND function returns the position (as a number) of one text string inside another."]
[]
[null,"Find","Within","Start_num","Result","Formula"]
[null,"e","elephant",null,{"$f":"FIND(B7,C7)","v":1},{"$f":"IF(_xlfn.ISFORMULA(E7),_xlfn.FORMULATEXT(E7),E7)","v":"=FIND(B7,C7)"}]
[null,"e","elephant",1,{"$f":"FIND(B8,C8,D8)","v":1},{"$f":"IF(_xlfn.ISFORMULA(E8),_xlfn.FORMULATEXT(E8),E8)","v":"=FIND(B8,C8,D8)"}]
[null,"e","elephant",2,{"$f":"FIND(B9,C9,D9)","v":3},"=FIND(B9,C9,D9)"]
[null,"ant","Elephant",1,{"$f":"FIND(B10,C10)","v":6},"=FIND(B10,C10)"]
[null,"abc","ABCABcAbcabc",1,10,"=FIND(B11,C11)"]
[null,"000?","01-ABC-001000",1,{"$error":"#VALUE!"},{"$f":"IF(_xlfn.ISFORMULA(E12),_xlfn.FORMULATEXT(E12),E12)","v":"=FIND(B12,C12)"}]
[null,"?000","01-ABC-001000",1,{"$error":"#VALUE!"},{"$f":"IF(_xlfn.ISFORMULA(E13),_xlfn.FORMULATEXT(E13),E13)","v":"=FIND(B13,C13)"}]
[]
[null,"automateexcel.com/functions/find-formula-excel"]
[]
[null,"Excel Boot Camp - Learn Excel Inside Excel"]

{"sheet":"First Name and Last name","index":2,"n_rows":10,"n_cols":3,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
["Full Name","First Name","Last Name"]
["Jeremy John",{"$f":"LEFT(A2,FIND(\" \",A2)-1)","v":"Jeremy"},{"$f":"RIGHT(A2,LEN(A2)-FIND(\" \",A2))","v":"John"}]
["John Jeremy","John","Jeremy"]
["Smith Daniel","Smith","Daniel"]
[]
["Function",{"$f":"IF(_xlfn.ISFORMULA(B2),_xlfn.FORMULATEXT(B2),B2)","v":"=LEFT(A2,FIND(\" \",A2)-1)"},{"$f":"IF(_xlfn.ISFORMULA(C2),_xlfn.FORMULATEXT(C2),C2)","v":"=RIGHT(A2,LEN(A2)-FIND(\" \",A2))"}]
[]
[null,"automateexcel.com/functions/find-formula-excel"]
[]
[null,"Excel Boot Camp - Learn Excel Inside Excel"]

{"sheet":"Find nth Character","index":3,"n_rows":8,"n_cols":5,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
["Full Name","1st \"e\"","2nd \"e\"","3rd \"e\"","4th \"e\""]
["eleven  elephant",{"$f":"FIND(\"e\",A2)","v":1},{"$f":"FIND(\"e\",A2,FIND(\"e\",A2)+1)","v":3},{"$f":"FIND(\"e\",A2, FIND(\"e\", A2, FIND(\"e\",A2)+1) +2)","v":5},{"$f":"FIND(\"e\",A2,FIND(\"e\",A2,FIND(\"e\",A2,FIND(\"e\",A2)+1))+2)+3","v":8}]
[]
["Function",{"$f":"IF(_xlfn.ISFORMULA(B2),_xlfn.FORMULATEXT(B2),B2)","v":"=FIND(\"e\",A2)"},{"$f":"IF(_xlfn.ISFORMULA(C2),_xlfn.FORMULATEXT(C2),C2)","v":"=FIND(\"e\",A2,FIND(\"e\",A2)+1)"},{"$f":"IF(_xlfn.ISFORMULA(D2),_xlfn.FORMULATEXT(D2),D2)","v":"=FIND(\"e\",A2, FIND(\"e\", A2, FIND(\"e\",A2)+1) +2)"},{"$f":"IF(_xlfn.ISFORMULA(E2),_xlfn.FORMULATEXT(E2),E2)","v":"=FIND(\"e\",A2,FIND(\"e\",A2,FIND(\"e\",A2,FIND(\"e\",A2)+1))+2)+3"}]
[]
[null,"automateexcel.com/functions/find-formula-excel"]
[]
[null,"Excel Boot Camp - Learn Excel Inside Excel"]

{"sheet":"Find Vs Search","index":4,"n_rows":17,"n_cols":3,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
["Full Name","Find _Eleven","Search_Eleven"]
["Eleven  Elephant",{"$f":"FIND(\"Eleven\",A2)","v":1},{"$f":"SEARCH(\"Eleven\",A2)","v":1}]
["ELEVEN  ELEPHANT",{"$f":"FIND(\"Eleven\",A3)","v":{"$error":"#VALUE!"}},1]
["eleven  elephant",{"$error":"#VALUE!"},1]
[]
["Function",{"$f":"IF(_xlfn.ISFORMULA(B2),_xlfn.FORMULATEXT(B2),B2)","v":"=FIND(\"Eleven\",A2)"},{"$f":"IF(_xlfn.ISFORMULA(C2),_xlfn.FORMULATEXT(C2),C2)","v":"=SEARCH(\"Eleven\",A2)"}]
[]
[]
["Full Name","Find _e","Search_e"]
["Eleven",{"$f":"FIND(\"e\",A10)","v":3},{"$f":"SEARCH(\"e\",A10)","v":1}]
["eleven",1,1]
[]
["Function",{"$f":"IF(_xlfn.ISFORMULA(B10),_xlfn.FORMULATEXT(B10),B10)","v":"=FIND(\"e\",A10)"},{"$f":"IF(_xlfn.ISFORMULA(C10),_xlfn.FORMULATEXT(C10),C10)","v":"=SEARCH(\"e\",A10)"}]
[]
[null,"automateexcel.com/functions/find-formula-excel"]
[]
[null,"Excel Boot Camp - Learn Excel Inside Excel"]

{"sheet":"Find middle Part","index":5,"n_rows":14,"n_cols":2,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
["Serial number","Middle Detail"]
["AB1XCDC-1BB/BB99",{"$f":"MID(A2,FIND(\"-\",A2)+1,FIND(\"/\",A2)-FIND(\"-\",A2)-1)","v":"1BB"}]
["BVDE9Z-9UFDU/PMO65","9UFDU"]
["TDCU-1VFDC/BV4","1VFDC"]
["N55-1PT/AB3478","1PT"]
["ASHHGHCN-1ZZ/C9","1ZZ"]
["GXH11-1DAA/DS96000HB","1DAA"]
["BBhghND-1ZDZ/CD90","1ZDZ"]
[]
["Function",{"$f":"IF(_xlfn.ISFORMULA(B2),_xlfn.FORMULATEXT(B2),B2)","v":"=MID(A2,FIND(\"-\",A2)+1,FIND(\"/\",A2)-FIND(\"-\",A2)-1)"}]
[]
[null,"automateexcel.com/functions/find-formula-excel"]
[]
[null,"Excel Boot Camp - Learn Excel Inside Excel"]