{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Find_Replace","Flash_Fill","LEFT_SEARCH","LEFT_FIND","Nth_Occurrence","Last_Occurrence","VBA"],"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":"Find_Replace","index":0,"n_rows":9,"n_cols":11,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Use of Find and Replace",null,null,null,null,null,null,null,null,"Try Yourself"]
[]
[null,"Code",null,null,null,null,null,null,null,null,"Code"]
[null,"Adelle",null,null,null,null,null,null,null,null,"Adelle, Engineer, CEO, 2232"]
[null,"Mitchell",null,null,null,null,null,null,null,null,"Mitchell, Engineer, CTO, 79898"]
[null,"John",null,null,null,null,null,null,null,null,"John, Engineer, BA, 7847"]
[null,"Emily",null,null,null,null,null,null,null,null,"Emily, Engineer, PO, 6787"]
[null,"Mark",null,null,null,null,null,null,null,null,"Mark, Doctor, Surgeon, 6768"]

{"sheet":"Flash_Fill","index":1,"n_rows":9,"n_cols":12,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,10,1,11]]}
[]
[null,"Use of Flash Fill",null,null,null,null,null,null,null,null,"Try Yourself"]
[]
[null,"Code 1","Names",null,null,null,null,null,null,null,"Code 1","Names"]
[null,"Adelle, Engineer, CEO, 2232","Adelle",null,null,null,null,null,null,null,"Adelle, Engineer, CEO, 2232"]
[null,"Mitchell, Engineer, CTO, 79898","Mitchell",null,null,null,null,null,null,null,"Mitchell, Engineer, CTO, 79898"]
[null,"John, Engineer, BA, 7847","John",null,null,null,null,null,null,null,"John, Engineer, BA, 7847"]
[null,"Emily, Engineer, PO, 6787","Emily",null,null,null,null,null,null,null,"Emily, Engineer, PO, 6787"]
[null,"Mark, Doctor, Surgeon, 6768","Mark",null,null,null,null,null,null,null,"Mark, Doctor, Segeon, 6768"]

{"sheet":"LEFT_SEARCH","index":2,"n_rows":9,"n_cols":12,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,10,1,11]]}
[]
[null,"Combination of LEFT & SEARCH Functions",null,null,null,null,null,null,null,null,"Try Yourself"]
[]
[null,"Code 1","Names",null,null,null,null,null,null,null,"Code 1","Result"]
[null,"Adelle, Engineer",{"$f":"LEFT(B5,SEARCH(\",\",B5)-1)","v":"Adelle"},null,null,null,null,null,null,null,"Adelle, Engineer"]
[null,"Mitchell, Psycologist",{"$f":"LEFT(B6,SEARCH(\",\",B6)-1)","v":"Mitchell"},null,null,null,null,null,null,null,"Mitchell, Psycologist"]
[null,"John, Doctor","John",null,null,null,null,null,null,null,"John, Doctor"]
[null,"Emily, Business Analyst","Emily",null,null,null,null,null,null,null,"Emily, Business Analyst"]
[null,"Mark, Product Owner","Mark",null,null,null,null,null,null,null,"Mark, Product Owner"]

{"sheet":"LEFT_FIND","index":3,"n_rows":9,"n_cols":12,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,10,1,11]]}
[]
[null,"Combination of LEFT & FIND Functions",null,null,null,null,null,null,null,null,"Try Yourself"]
[]
[null,"Code 1","Names",null,null,null,null,null,null,null,"Code 1","Names"]
[null,"Adelle, Engineer",{"$f":"LEFT(B5,FIND(\",\",B5)-1)","v":"Adelle"},null,null,null,null,null,null,null,"Adelle, Engineer"]
[null,"Mitchell, Psycologist",{"$f":"LEFT(B6,FIND(\",\",B6)-1)","v":"Mitchell"},null,null,null,null,null,null,null,"Mitchell, Psycologist"]
[null,"John, Doctor","John",null,null,null,null,null,null,null,"John, Doctor"]
[null,"Emily, Business Analyst","Emily",null,null,null,null,null,null,null,"Emily, Business Analyst"]
[null,"Mark, Product Owner","Mark",null,null,null,null,null,null,null,"Mark, Product Owner"]

{"sheet":"Nth_Occurrence","index":4,"n_rows":9,"n_cols":12,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,10,1,11]]}
[]
[null,"Delete Everything After Nth Occurrence",null,null,null,null,null,null,null,null,"Try Yourself"]
[]
[null,"Code 1","Result",null,null,null,null,null,null,null,"Code 1","Result"]
[null,"Adelle, Engineer, CEO, 2232",{"$f":"LEFT(B5,FIND(\"#\",SUBSTITUTE(B5,\",\",\"#\",2))-1)","v":"Adelle, Engineer"},null,null,null,null,null,null,null,"Adelle, Engineer, CEO, 2232"]
[null,"Mitchell, Engineer, CTO, 7989",{"$f":"LEFT(B6,FIND(\"#\",SUBSTITUTE(B6,\",\",\"#\",2))-1)","v":"Mitchell, Engineer"},null,null,null,null,null,null,null,"Mitchell, Engineer, CTO, 7989"]
[null,"John, Engineer, BA, 7847","John, Engineer",null,null,null,null,null,null,null,"John, Engineer, BA, 7847"]
[null,"Emily, Engineer, PO, 6787","Emily, Engineer",null,null,null,null,null,null,null,"Emily, Engineer, PO, 6787"]
[null,"Mark, Doctor, Surgeon, 6768","Mark, Doctor",null,null,null,null,null,null,null,"Mark, Doctor, Surgeon, 6768"]

{"sheet":"Last_Occurrence","index":5,"n_rows":9,"n_cols":12,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,10,1,11]]}
[]
[null,"Delete Everything After Last Occurrence",null,null,null,null,null,null,null,null,"Try Yourself"]
[]
[null,"Code 1","Result",null,null,null,null,null,null,null,"Code 1","Result"]
[null,"Adelle, Engineer, CEO, 2232",{"$f":"LEFT(B5,FIND(\"#\",SUBSTITUTE(B5,\",\",\"#\",LEN(B5)-LEN(SUBSTITUTE(B5,\",\",\"\"))))-1)","v":"Adelle, Engineer, CEO"},null,null,null,null,null,null,null,"Adelle, Engineer, CEO, 2232"]
[null,"Mitchell, Engineer, CTO, 7989",{"$f":"LEFT(B6,FIND(\"#\",SUBSTITUTE(B6,\",\",\"#\",LEN(B6)-LEN(SUBSTITUTE(B6,\",\",\"\"))))-1)","v":"Mitchell, Engineer, CTO"},null,null,null,null,null,null,null,"Mitchell, Engineer, CTO, 7989"]
[null,"John, Engineer, BA, 7847","John, Engineer, BA",null,null,null,null,null,null,null,"John, Engineer, BA, 7847"]
[null,"Emily, Engineer, PO, 6787","Emily, Engineer, PO",null,null,null,null,null,null,null,"Emily, Engineer, PO, 6787"]
[null,"Mark, Doctor, Surgeon, 6768","Mark, Doctor, Surgeon",null,null,null,null,null,null,null,"Mark, Doctor, Surgeon, 6768"]

{"sheet":"VBA","index":6,"n_rows":9,"n_cols":12,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,10,1,11]]}
[]
[null,"Use of VBA",null,null,null,null,null,null,null,null,"Try Yourself"]
[]
[null,"Code 1","Names",null,null,null,null,null,null,null,"Code 1","Names"]
[null,"Adelle, Engineer","Adelle",null,null,null,null,null,null,null,"Adelle, Engineer"]
[null,"Mitchell, Psycologist","Mitchell",null,null,null,null,null,null,null,"Mitchell, Psycologist"]
[null,"John, Doctor","John",null,null,null,null,null,null,null,"John, Doctor"]
[null,"Emily, Business Analyst","Emily",null,null,null,null,null,null,null,"Emily, Business Analyst"]
[null,"Mark, Product Owner","Mark",null,null,null,null,null,null,null,"Mark, Product Owner"]