{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Case of String","CHAR Function","REPLACE Function","TRIM & LEN Function","LEFT MID RIGHT Function","FIND & SEARCH Function","Extracting Substring","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":"Case of String","index":0,"n_rows":14,"n_cols":4,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"UPPER, LOWER and PROPER Function"]
[]
[null,"Name","Result Upper Case","Formula Used"]
[null,"jack Ruster",{"$f":"UPPER(B5)","v":"JACK RUSTER"},"=UPPER(B5)"]
[null,"jOy akien",{"$f":"UPPER(B6)","v":"JOY AKIEN"},"=UPPER(B6)"]
[]
[null,"Name","Result Lower Case","Formula Used"]
[null,"jack Ruster",{"$f":"LOWER(B9)","v":"jack ruster"},"=LOWER(B9)"]
[null,"jOy akien",{"$f":"LOWER(B10)","v":"joy akien"},"=LOWER(B10)"]
[]
[null,"Name","Result Upper Case","Formula Used"]
[null,"jack Ruster",{"$f":"PROPER(B13)","v":"Jack Ruster"},"=PROPER(B13)"]
[null,"jOy akien",{"$f":"PROPER(B14)","v":"Joy Akien"},"=PROPER(B14)"]

{"sheet":"CHAR Function","index":1,"n_rows":14,"n_cols":4,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"CHAR Function"]
[]
[null,"Code ","CHAR ","Formula"]
[null,35,{"$f":"CHAR(B5)","v":"#"},{"$f":"CONCATENATE(\"=CHAR(\",B5,\")\")","v":"=CHAR(35)"}]
[null,36,"$","=CHAR(36)"]
[null,37,"%","=CHAR(37)"]
[null,63,"?","=CHAR(63)"]
[null,166,"¦","=CHAR(166)"]
[null,167,"§","=CHAR(167)"]
[null,66,"B","=CHAR(66)"]
[null,67,"C","=CHAR(67)"]
[null,68,"D","=CHAR(68)"]
[null,69,"E",{"$f":"CONCATENATE(\"=CHAR(\",B14,\")\")","v":"=CHAR(69)"}]

{"sheet":"REPLACE Function","index":2,"n_rows":10,"n_cols":3,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"REPLACE Function"]
[]
[null,"Product ID","New ID"]
[null,"NB 5001",{"$f":"REPLACE(B5,1,2,\"RS\")","v":"RS 5001"}]
[null,"NB 5005",{"$f":"REPLACE(B6,1,2,\"RS\")","v":"RS 5005"}]
[null,"NB 5016","RS 5016"]
[null,"NB 5019","RS 5019"]
[null,"NB 5025","RS 5025"]
[null,"NB 5032","RS 5032"]

{"sheet":"TRIM & LEN Function","index":3,"n_rows":9,"n_cols":4,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"TRIM and LEN Functions"]
[]
[null,"Movie","Name After TRIM","Number of Characters"]
[null,"A Few   Good Men   ",{"$f":"TRIM(B5)","v":"A Few Good Men"},{"$f":"LEN(C5)","v":14}]
[null,"  Pet  Sematary  ",{"$f":"TRIM(B6)","v":"Pet Sematary"},{"$f":"LEN(C6)","v":12}]
[null,"          Primal         Fear","Primal Fear",11]
[null,"   The Trial of    the Chicago    7   ","The Trial of the Chicago 7",26]
[null,"The            Prestige","The Prestige",12]

{"sheet":"LEFT MID RIGHT Function","index":4,"n_rows":14,"n_cols":4,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"LEFT, MID and RIGHT Functions"]
[]
[null,"Example","LEFT Function","Formula"]
[null,"Name: Jack Height: 192 cm Weight: 75 kg",{"$f":"LEFT(B5,10)","v":"Name: Jack"},"=LEFT(B5,10)"]
[null,"Name: Marie Height: 172 cm Weight: 55 kg",{"$f":"LEFT(B6,11)","v":"Name: Marie"},"=LEFT(B6,11)"]
[]
[null,null,"MID Function","Formula"]
[null,null,{"$f":"MID(B5,11,15)","v":" Height: 192 cm"},"=MID(B5,11,15)"]
[null,null,{"$f":"MID(B6,12,15)","v":" Height: 172 cm"},"=MID(B6,12,15)"]
[]
[null,null,"RIGHT Function","Formula"]
[null,null,{"$f":"RIGHT(B5,13)","v":"Weight: 75 kg"},"=RIGHT(B5,13)"]
[null,null,{"$f":"RIGHT(B6,13)","v":"Weight: 55 kg"},"=RIGHT(B6,13)"]

{"sheet":"FIND & SEARCH Function","index":5,"n_rows":13,"n_cols":4,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"FIND and SEARCH Functions"]
[]
[null,"Text","Find","Position"]
[null,"32-1-FQW-82","F",{"$f":"FIND(C5,B5)","v":6}]
[null,"256-QOGT-64","GT",{"$f":"FIND(C6,B6)","v":7}]
[null,"6G-52E-58632",86,9]
[]
[]
[null,"Book Name","Book Type","Search for \"Novel\""]
[null,"A Tale of Two Cities","Historical Novel",{"$f":"SEARCH(\"Novel\",C11,1)","v":12}]
[null,"Great Expectations","Biographical Novel",{"$f":"SEARCH(\"Novel\",C12,1)","v":14}]
[null,"Lucifer","Novel",{"$f":"SEARCH(\"Novel\",C13,1)","v":1}]

{"sheet":"Extracting Substring","index":6,"n_rows":9,"n_cols":5,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Combining UPPER, LEFT and SEARCH Functions"]
[]
[null,"Item Description","Item","Color","Size"]
[null,"Shirt-Violet-M",{"$f":"UPPER(LEFT(B5,SEARCH(\"-\",B5,1)-1))","v":"SHIRT"},{"$f":"PROPER(MID(B5, SEARCH(\"-\",B5) + 1, SEARCH(\"-\",B5,SEARCH(\"-\",B5)+1) - SEARCH(\"-\",B5) - 1))","v":"Violet"},{"$f":"LOWER(RIGHT(B5,LEN(B5)-SEARCH(\"-\",B5, SEARCH(\"-\",B5) + 1)))","v":"m"}]
[null,"Tshirt-Black-L",{"$f":"UPPER(LEFT(B6,SEARCH(\"-\",B6,1)-1))","v":"TSHIRT"},{"$f":"PROPER(MID(B6, SEARCH(\"-\",B6) + 1, SEARCH(\"-\",B6,SEARCH(\"-\",B6)+1) - SEARCH(\"-\",B6) - 1))","v":"Black"},{"$f":"LOWER(RIGHT(B6,LEN(B6)-SEARCH(\"-\",B6, SEARCH(\"-\",B6) + 1)))","v":"l"}]
[null,"Jeans-Blue-S","JEANS","Blue","s"]
[null,"Coat-White-XL","COAT","White","xl"]
[null,"Shorts-Red-XXL","SHORTS","Red","xxl"]

{"sheet":"VBA","index":7,"n_rows":7,"n_cols":5,"rows_kept":7,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Applying VBA"]
[]
[null,"Text","Letter","Digit","Other"]
[null,"c1o2n3bina454$%tion","conbination",123454,"$%"]
[null,"1mo#r2n3ing","morning",123,"#"]
[null,"Good904lett*%er","Goodletter",904,"*%"]