{"text_format":"1","workbook":"xlsx","n_sheets":11,"sheets":["Find","SUBSTITUTE","Flash","First","Last","Both","Before","After","REPLACE","VBA1","VBA2"],"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","index":0,"n_rows":10,"n_cols":12,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Use of Find & Replace Option",null,null,null,null,null,null,null,null,null,"Try Yourself"]
[]
[null,"Data",null,null,null,null,null,null,null,null,null,"Data"]
[null,"Andrew Yang",null,null,null,null,null,null,null,null,null,"Full Name: Andrew Yang"]
[null,"Adam Smith",null,null,null,null,null,null,null,null,null,"Full Name: Adam Smith"]
[null,"Michel Clark",null,null,null,null,null,null,null,null,null,"Full Name: Michel Clark"]
[null,"Emily Williams",null,null,null,null,null,null,null,null,null,"Full Name: Emily Williams"]
[null,"June Brown",null,null,null,null,null,null,null,null,null,"Full Name: June Brown"]
[null,"John Miller",null,null,null,null,null,null,null,null,null,"Full Name: John Miller"]

{"sheet":"SUBSTITUTE","index":1,"n_rows":10,"n_cols":13,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,11,1,12]]}
[]
[null,"Use of SUBSTITUTE Function",null,null,null,null,null,null,null,null,null,"Try Yourself"]
[]
[null,"Data","Result",null,null,null,null,null,null,null,null,"Data","Result"]
[null,"Full Name: Andrew Yang",{"$f":"SUBSTITUTE(B5,\"Full Name:\",\"\")","v":" Andrew Yang"},null,null,null,null,null,null,null,null,"Full Name: Andrew Yang",{"$f":"SUBSTITUTE(L5,\"Full Name:\",\"\")","v":" Andrew Yang"}]
[null,"Full Name: Adam Smith",{"$f":"SUBSTITUTE(B6,\"Full Name:\",\"\")","v":" Adam Smith"},null,null,null,null,null,null,null,null,"Full Name: Adam Smith",{"$f":"SUBSTITUTE(L6,\"Full Name:\",\"\")","v":" Adam Smith"}]
[null,"Full Name: Michel Clark"," Michel Clark",null,null,null,null,null,null,null,null,"Full Name: Michel Clark"," Michel Clark"]
[null,"Full Name: Emily Williams"," Emily Williams",null,null,null,null,null,null,null,null,"Full Name: Emily Williams"," Emily Williams"]
[null,"Full Name: June Brown"," June Brown",null,null,null,null,null,null,null,null,"Full Name: June Brown"," June Brown"]
[null,"Full Name: John Miller"," John Miller",null,null,null,null,null,null,null,null,"Full Name: John Miller"," John Miller"]

{"sheet":"Flash","index":2,"n_rows":10,"n_cols":14,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,12,1,13]]}
[]
[null,"Use of Flash Fill",null,null,null,null,null,null,null,null,null,null,"Try Yourself"]
[]
[null,"Data","Result",null,null,null,null,null,null,null,null,null,"Data","Result"]
[null,"Andrew, Teacher","Teacher",null,null,null,null,null,null,null,null,null,"Andrew, Teacher","Teacher"]
[null,"Adam, Engineer","Engineerung",null,null,null,null,null,null,null,null,null,"Adam, Engineer","Engineerung"]
[null,"Michel, Actor","Actorung",null,null,null,null,null,null,null,null,null,"Michel, Actor","Actorung"]
[null,"June, Doctor","Doctorung",null,null,null,null,null,null,null,null,null,"June, Doctor","Doctorung"]
[null,"John, Architect","Architectung",null,null,null,null,null,null,null,null,null,"John, Architect","Architectung"]
[null,"Mark, Chef","Chefung",null,null,null,null,null,null,null,null,null,"Mark, Chef","Chefung"]

{"sheet":"First","index":3,"n_rows":10,"n_cols":13,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,11,1,12]]}
[]
[null,"Use of RIGHT & LEN Functions",null,null,null,null,null,null,null,null,null,"Try Yourself"]
[]
[null,"Data","Result",null,null,null,null,null,null,null,null,"Data","Result"]
[null,"9#Andrew Yang",{"$f":"RIGHT(B5,LEN(B5)-2)","v":"Andrew Yang"},null,null,null,null,null,null,null,null,"9#Andrew Yang"]
[null,"8#Adam Smith","Adam Smith",null,null,null,null,null,null,null,null,"8#Adam Smith"]
[null,"6#Michel Clark","Michel Clark",null,null,null,null,null,null,null,null,"6#Michel Clark"]
[null,"7#Emily Williams","Emily Williams",null,null,null,null,null,null,null,null,"7#Emily Williams"]
[null,"2#June Brown","June Brown",null,null,null,null,null,null,null,null,"2#June Brown"]
[null,"5#John Miller","John Miller",null,null,null,null,null,null,null,null,"5#John Miller"]

{"sheet":"Last","index":4,"n_rows":10,"n_cols":13,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,11,1,12]]}
[]
[null,"Use of LEFT & LEN Functions",null,null,null,null,null,null,null,null,null,"Try Yourself"]
[]
[null,"Data","Result",null,null,null,null,null,null,null,null,"Data","Result"]
[null,"Andrew Yang-3343",{"$f":"LEFT(B5,LEN(B5)-5)","v":"Andrew Yang"},null,null,null,null,null,null,null,null,"Andrew Yang-3343"]
[null,"Adam Smith-6789",{"$f":"LEFT(B6,LEN(B6)-5)","v":"Adam Smith"},null,null,null,null,null,null,null,null,"Adam Smith-6789"]
[null,"Michel Clark-8900","Michel Clark",null,null,null,null,null,null,null,null,"Michel Clark-8900"]
[null,"Emily Williams-3452","Emily Williams",null,null,null,null,null,null,null,null,"Emily Williams-3452"]
[null,"June Brown-4567","June Brown",null,null,null,null,null,null,null,null,"June Brown-4567"]
[null,"John Miller-3467","John Miller",null,null,null,null,null,null,null,null,"John Miller-3467"]

{"sheet":"Both","index":5,"n_rows":10,"n_cols":13,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,11,1,12]]}
[]
[null,"Use of MID & LEN Functions",null,null,null,null,null,null,null,null,null,"Try Yourself"]
[]
[null,"Data","Result",null,null,null,null,null,null,null,null,"Data","Result"]
[null,"9#Andrew Yang-2345",{"$f":"MID(B5,3,LEN(B5)-7)","v":"Andrew Yang"},null,null,null,null,null,null,null,null,"9#Andrew Yang-2345"]
[null,"8#Adam Smith-4567",{"$f":"MID(B6,3,LEN(B6)-7)","v":"Adam Smith"},null,null,null,null,null,null,null,null,"8#Adam Smith-4567"]
[null,"6#Michel Clark-1234","Michel Clark",null,null,null,null,null,null,null,null,"6#Michel Clark-1234"]
[null,"7#Emily Williams-7892","Emily Williams",null,null,null,null,null,null,null,null,"7#Emily Williams-7892"]
[null,"2#June Brown-8699","June Brown",null,null,null,null,null,null,null,null,"2#June Brown-8699"]
[null,"5#John Miller-6894","John Miller",null,null,null,null,null,null,null,null,"5#John Miller-6894"]

{"sheet":"Before","index":6,"n_rows":10,"n_cols":13,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,11,1,12]]}
[]
[null,"Trim Text before a Specific Character",null,null,null,null,null,null,null,null,null,"Try Yourself"]
[]
[null,"Data","Result",null,null,null,null,null,null,null,null,"Data","Result"]
[null,"Andrew, Teacher",{"$f":"RIGHT(B5,LEN(B5)-SEARCH(\",\",B5))","v":" Teacher"},null,null,null,null,null,null,null,null,"Andrew, Teacher"]
[null,"Adam, Engineer",{"$f":"RIGHT(B6,LEN(B6)-SEARCH(\",\",B6))","v":" Engineer"},null,null,null,null,null,null,null,null,"Adam, Engineer"]
[null,"Michel, Actor"," Actor",null,null,null,null,null,null,null,null,"Michel, Actor"]
[null,"June, Doctor"," Doctor",null,null,null,null,null,null,null,null,"June, Doctor"]
[null,"John, Architect"," Architect",null,null,null,null,null,null,null,null,"John, Architect"]
[null,"Mark, Chef"," Chef",null,null,null,null,null,null,null,null,"Mark, Chef"]

{"sheet":"After","index":7,"n_rows":10,"n_cols":13,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,11,1,12]]}
[]
[null,"Trim Text after a Specific Character",null,null,null,null,null,null,null,null,null,"Try Yourself"]
[]
[null,"Data","Result",null,null,null,null,null,null,null,null,"Data","Result"]
[null,"Andrew, Teacher",{"$f":"LEFT(B5,7-1)","v":"Andrew"},null,null,null,null,null,null,null,null,"Andrew, Teacher"]
[null,"Adam, Engineer",{"$f":"LEFT(B6,SEARCH(\",\",B6)-1)","v":"Adam"},null,null,null,null,null,null,null,null,"Adam, Engineer"]
[null,"Michel, Actor","Michel",null,null,null,null,null,null,null,null,"Michel, Actor"]
[null,"June, Doctor","June",null,null,null,null,null,null,null,null,"June, Doctor"]
[null,"John, Architect","John",null,null,null,null,null,null,null,null,"John, Architect"]
[null,"Mark, Chef","Mark",null,null,null,null,null,null,null,null,"Mark, Chef"]

{"sheet":"REPLACE","index":8,"n_rows":10,"n_cols":13,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,11,1,12]]}
[]
[null,"Use of REPLACE Function",null,null,null,null,null,null,null,null,null,"Try Yourself"]
[]
[null,"Data","Result",null,null,null,null,null,null,null,null,"Data","Result"]
[null,"June Miller, Teacher",{"$f":"REPLACE(B5,1,13,\" \")","v":" Teacher"},null,null,null,null,null,null,null,null,"June Miller, Teacher"]
[null,"June Miller, Engineer",{"$f":"REPLACE(B6,1,13,\" \")","v":" Engineer"},null,null,null,null,null,null,null,null,"June Miller, Engineer"]
[null,"June Miller, Actor"," Actor",null,null,null,null,null,null,null,null,"June Miller, Actor"]
[null,"June Miller, Doctor"," Doctor",null,null,null,null,null,null,null,null,"June Miller, Doctor"]
[null,"June Miller, Architect"," Architect",null,null,null,null,null,null,null,null,"June Miller, Architect"]
[null,"June Miller, Chef"," Chef",null,null,null,null,null,null,null,null,"June Miller, Chef"]

{"sheet":"VBA1","index":9,"n_rows":10,"n_cols":13,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,11,1,12]]}
[]
[null,"Use of VBA (Trim First N Characters)",null,null,null,null,null,null,null,null,null,"Try Yourself"]
[]
[null,"Data","Result",null,null,null,null,null,null,null,null,"Data","Result"]
[null,"9#Andrew Yang",{"$f":"TrimFirstn(B5,2)","v":"Andrew Yang"},null,null,null,null,null,null,null,null,"9#Andrew Yang"]
[null,"8#Adam Smith",{"$f":"TrimFirstn(B6,2)","v":"Adam Smith"},null,null,null,null,null,null,null,null,"8#Adam Smith"]
[null,"6#Michel Clark",{"$f":"TrimFirstn(B7,2)","v":"Michel Clark"},null,null,null,null,null,null,null,null,"6#Michel Clark"]
[null,"7#Emily Williams",{"$f":"TrimFirstn(B8,2)","v":"Emily Williams"},null,null,null,null,null,null,null,null,"7#Emily Williams"]
[null,"2#June Brown",{"$f":"TrimFirstn(B9,2)","v":"June Brown"},null,null,null,null,null,null,null,null,"2#June Brown"]
[null,"5#John Miller",{"$f":"TrimFirstn(B10,2)","v":"John Miller"},null,null,null,null,null,null,null,null,"5#John Miller"]

{"sheet":"VBA2","index":10,"n_rows":10,"n_cols":13,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,11,1,12]]}
[]
[null,"Use of VBA (Trim Last N Characters)",null,null,null,null,null,null,null,null,null,"Try Yourself"]
[]
[null,"Data","Result",null,null,null,null,null,null,null,null,"Data","Result"]
[null,"Andrew Yang-3343",{"$f":"TrimLastn(B5,5)","v":"Andrew Yang"},null,null,null,null,null,null,null,null,"Andrew Yang-3343"]
[null,"Adam Smith-6789",{"$f":"TrimLastn(B6,5)","v":"Adam Smith"},null,null,null,null,null,null,null,null,"Adam Smith-6789"]
[null,"Michel Clark-8900",{"$f":"TrimLastn(B7,5)","v":"Michel Clark"},null,null,null,null,null,null,null,null,"Michel Clark-8900"]
[null,"Emily Williams-3452",{"$f":"TrimLastn(B8,5)","v":"Emily Williams"},null,null,null,null,null,null,null,null,"Emily Williams-3452"]
[null,"June Brown-4567",{"$f":"TrimLastn(B9,5)","v":"June Brown"},null,null,null,null,null,null,null,null,"June Brown-4567"]
[null,"John Miller-3467",{"$f":"TrimLastn(B10,5)","v":"John Miller"},null,null,null,null,null,null,null,null,"John Miller-3467"]