{"text_format":"1","workbook":"xlsx","n_sheets":13,"sheets":["Dataset","Text1","Text2","Format_func","Conditional1","Conditional2","Conditional3","Conditional4","Conditional5","Right","Left","MID","FIND"],"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":"Dataset","index":0,"n_rows":15,"n_cols":6,"rows_kept":15,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Dataset"]
[]
[null,"Order ID","Items","Order Date","States","Sales"]
[null,101,"AC","2022-01-01","Ohio",3000]
[null,102,"TV","2022-01-02","Utah",1000]
[null,103,"Monitor","2022-01-03","Nevada",1500]
[null,104,"Fan","2022-01-04","Ohio",350]
[null,105,"TV","2022-01-05","Ohio",1500]
[null,106,"AC","2022-01-06","Nevada",1500]
[null,107,"TV","2022-01-07","Utah",1000]
[null,108,"Monitor","2022-01-08","Ohio",1500]
[null,109,"AC","2022-01-09","Nevada",4000]
[null,110,"TV","2022-01-10","Texas",2000]
[null,111,"Monitor","2022-01-11","Hawaii",2000]

{"sheet":"Text1","index":1,"n_rows":15,"n_cols":6,"rows_kept":15,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Cell Formatting Using TEXT Function"]
[]
[null,"Value","Format Text","Output ","Formula","Explanation"]
[null,1000,123456,{"$f":"TEXT(B5,C5)","v":"123456"},{"$f":"_xlfn.FORMULATEXT(D5)","v":"=TEXT(B5,C5)"},"Number in a specific format"]
[null,-1000,"0;0;0;@",{"$f":"TEXT(B6,C6)","v":"1000"},{"$f":"_xlfn.FORMULATEXT(D6)","v":"=TEXT(B6,C6)"},"Negative number to positive nujmber "]
[null,1000,"\"-0;-0;0;@\"",{"$f":"TEXT(B7,\"-0;-0;0;@\")","v":"-1000"},"=TEXT(B7,\"-0;-0;0;@\")","Positive number to negative number"]
[null,1000,0,{"$f":"TEXT(B8,\"0.0E+0\")","v":"1.0E+3"},"=TEXT(B8,\"0.0E+0\")","Number in a scientific format"]
[null,44562,"ddd","Sat","=TEXT(B9,C9)","Name of Day from a date"]
[null,44562,"mmm","Jan","=TEXT(B10,C10)","Name of Month from a date"]
[null,0.4993055555555555,"hh:mm:ss","11:59:00","=TEXT(B11,C11)","Time in specific format"]
[null,1234,null,{"$f":"TEXT(B12,\"0000000\")","v":"0001234"},"=TEXT(B12,\"0000000\")","Number with leading zeros"]
[null,123456,"###-####",{"$f":"TEXT(B13,C13)","v":"12-3456"},{"$f":"_xlfn.FORMULATEXT(D13)","v":"=TEXT(B13,C13)"},"Number in a specific format"]
[null,null,null,""]
[null,null,null,""]

{"sheet":"Text2","index":2,"n_rows":15,"n_cols":6,"rows_kept":15,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Cell Formatting Using TEXT Function"]
[]
[null,"Items","Price","Qty","Sales","Formula"]
[null,"AC",300,10,{"$f":"\"The Sales is \"&TEXT(C5*D5, \"$###,###.00\")","v":"The Sales is $3,000.00"},{"$f":"_xlfn.FORMULATEXT(E5)","v":"=\"The Sales is \"&TEXT(C5*D5, \"$###,###.00\")"}]
[null,"TV",200,5,{"$f":"\"The Sales is \"&TEXT(C6*D6, \"$###,###.00\")","v":"The Sales is $1,000.00"},{"$f":"_xlfn.FORMULATEXT(E6)","v":"=\"The Sales is \"&TEXT(C6*D6, \"$###,###.00\")"}]
[null,"Monitor",150,10,"The Sales is $1,500.00","=\"The Sales is \"&TEXT(C7*D7, \"$###,###.00\")"]
[null,"Fan",70,5,"The Sales is $350.00","=\"The Sales is \"&TEXT(C8*D8, \"$###,###.00\")"]
[null,"TV",300,5,"The Sales is $1,500.00","=\"The Sales is \"&TEXT(C9*D9, \"$###,###.00\")"]
[null,"AC",300,5,"The Sales is $1,500.00","=\"The Sales is \"&TEXT(C10*D10, \"$###,###.00\")"]
[null,"TV",200,5,"The Sales is $1,000.00","=\"The Sales is \"&TEXT(C11*D11, \"$###,###.00\")"]
[null,"Monitor",150,10,"The Sales is $1,500.00","=\"The Sales is \"&TEXT(C12*D12, \"$###,###.00\")"]
[null,"AC",200,20,"The Sales is $4,000.00","=\"The Sales is \"&TEXT(C13*D13, \"$###,###.00\")"]
[null,"TV",200,10,"The Sales is $2,000.00","=\"The Sales is \"&TEXT(C14*D14, \"$###,###.00\")"]
[null,"Monitor",150,15,"The Sales is $2,250.00","=\"The Sales is \"&TEXT(C15*D15, \"$###,###.00\")"]

{"sheet":"Format_func","index":3,"n_rows":11,"n_cols":3,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"VBA Format Function"]
[]
[null,"Data","Output"]
[null,123456,123456]
[null,"2022-01-01","Saturday, January 1, 2022"]
[null,1,true]
[null,12345,12345]
[null,12345,12345]
[null,"11:59:00","11:59:00"]
[null,"2022-01-01","2022-01-01"]

{"sheet":"Conditional1","index":4,"n_rows":15,"n_cols":6,"rows_kept":15,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Conditional Formatting with Formulas"]
[]
[null,"Order ID","Items","Order Date","States","Sales"]
[null,101,"AC","2022-01-01","Ohio",3000]
[null,102,"TV","2022-01-02","Utah",1000]
[null,103,"Monitor","2022-01-03","Nevada",1500]
[null,104,"Fan","2022-01-04","Ohio",350]
[null,105,"TV","2022-01-05","Ohio",1500]
[null,106,"AC","2022-01-06","Nevada",1500]
[null,107,"TV","2022-01-07","Utah",1000]
[null,108,"Monitor","2022-01-08","Ohio",1500]
[null,109,"AC","2022-01-09","Nevada",4000]
[null,110,"TV","2022-01-10","Texas",2000]
[null,111,"Monitor","2022-01-11","Hawaii",2000]

{"sheet":"Conditional2","index":5,"n_rows":15,"n_cols":6,"rows_kept":15,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Highlighting Orders from \"Ohio\""]
[]
[null,"Order ID","Items","Order Date","States","Sales"]
[null,101,"AC","2022-01-01","Ohio",3000]
[null,102,"TV","2022-01-02","Utah",1000]
[null,103,"Monitor","2022-01-03","Nevada",1500]
[null,104,"Fan","2022-01-04","Ohio",350]
[null,105,"TV","2022-01-05","Ohio",1500]
[null,106,"AC","2022-01-06","Nevada",1500]
[null,107,"TV","2022-01-07","Utah",1000]
[null,108,"Monitor","2022-01-08","Ohio",1500]
[null,109,"AC","2022-01-09","Nevada",4000]
[null,110,"TV","2022-01-10","Texas",2000]
[null,111,"Monitor","2022-01-11","Hawaii",2000]

{"sheet":"Conditional3","index":6,"n_rows":15,"n_cols":5,"rows_kept":15,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Highlighting Dates in Next 30 Days"]
[]
[null,"Order Date","Items","States","Sales"]
[null,"2022-01-01","AC","Ohio",3000]
[null,"2022-02-10","TV","Utah",1000]
[null,"2022-01-09","Monitor","Nevada",1500]
[null,"2022-01-13","Fan","Ohio",350]
[null,"2022-01-17","TV","Ohio",1500]
[null,"2022-01-01","AC","Nevada",1500]
[null,"2022-01-25","TV","Utah",1000]
[null,"2022-01-05","Monitor","Ohio",1500]
[null,"2022-02-02","AC","Nevada",4000]
[null,"2022-01-09","TV","Texas",2000]
[null,"2022-02-10","Monitor","Hawaii",2000]

{"sheet":"Conditional4","index":7,"n_rows":15,"n_cols":4,"rows_kept":15,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Highlight missing values"]
[]
[null,"List 1",null,"List 2"]
[null,"AC",null,"AC"]
[null,"TV",null,"Light"]
[null,"Monitor",null,"TV"]
[null,"Fan",null,"Fan"]
[null,"TV",null,"TV"]
[null,"AC",null,"Loudspeaker"]
[null,"TV",null,"TV"]
[null,"Monitor"]
[null,"AC"]
[null,"TV"]
[null,"Monitor"]

{"sheet":"Conditional5","index":8,"n_rows":15,"n_cols":7,"rows_kept":15,"cut":false,"hidden":false,"merged":[[1,1,1,6]]}
[]
[null,"Items Having Price is <=300 & Sales is >=2000"]
[]
[null,"Order ID","Items","Order Date","Price","States","Sales"]
[null,101,"AC","2022-01-01",300,"Ohio",3000]
[null,102,"TV","2022-01-02",200,"Utah",1000]
[null,103,"Monitor","2022-01-03",150,"Nevada",1500]
[null,104,"Fan","2022-01-04",70,"Ohio",350]
[null,105,"TV","2022-01-01",300,"Ohio",3000]
[null,106,"AC","2022-01-06",300,"Nevada",1500]
[null,107,"TV","2022-01-07",200,"Utah",1000]
[null,108,"Monitor","2022-01-08",150,"Ohio",1500]
[null,109,"AC","2022-01-01",200,"Nevada",1000]
[null,110,"TV","2022-01-10",200,"Texas",2000]
[null,111,"Monitor","2022-01-01",150,"Hawaii",2000]

{"sheet":"Right","index":9,"n_rows":15,"n_cols":5,"rows_kept":15,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Removing Left Characters"]
[]
[null,"Order ID-Items","Num Chars","Items","Formula"]
[null,"101AC",3,{"$f":"RIGHT(B5,LEN(B5)-C5)","v":"AC"},{"$f":"_xlfn.FORMULATEXT(D5)","v":"=RIGHT(B5,LEN(B5)-C5)"}]
[null,"102TV",3,{"$f":"RIGHT(B6,LEN(B6)-C6)","v":"TV"},{"$f":"_xlfn.FORMULATEXT(D6)","v":"=RIGHT(B6,LEN(B6)-C6)"}]
[null,"103Monitor",3,"Monitor","=RIGHT(B7,LEN(B7)-C7)"]
[null,"104Fan",3,"Fan","=RIGHT(B8,LEN(B8)-C8)"]
[null,"105TV",3,"TV","=RIGHT(B9,LEN(B9)-C9)"]
[null,"106AC",3,"AC","=RIGHT(B10,LEN(B10)-C10)"]
[null,"107TV",3,"TV","=RIGHT(B11,LEN(B11)-C11)"]
[null,"108Monitor",3,"Monitor","=RIGHT(B12,LEN(B12)-C12)"]
[null,"109AC",3,"AC","=RIGHT(B13,LEN(B13)-C13)"]
[null,"110TV",3,"TV","=RIGHT(B14,LEN(B14)-C14)"]
[null,"111Monitor",3,"Monitor","=RIGHT(B15,LEN(B15)-C15)"]

{"sheet":"Left","index":10,"n_rows":15,"n_cols":5,"rows_kept":15,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Retrieving Value"]
[]
[null,"Order ID-Items"," Chars","Order ID?","Formula"]
[null,"101AC",2,{"$f":"VALUE(LEFT(B5,(LEN(B5)-C5)))","v":101},{"$f":"_xlfn.FORMULATEXT(D5)","v":"=VALUE(LEFT(B5,(LEN(B5)-C5)))"}]
[null,"102TV",2,{"$f":"VALUE(LEFT(B6,(LEN(B6)-C6)))","v":102},{"$f":"_xlfn.FORMULATEXT(D6)","v":"=VALUE(LEFT(B6,(LEN(B6)-C6)))"}]
[null,"103Monitor",7,103,"=VALUE(LEFT(B7,(LEN(B7)-C7)))"]
[null,"104Fan",3,104,"=VALUE(LEFT(B8,(LEN(B8)-C8)))"]
[null,"105TV",2,105,"=VALUE(LEFT(B9,(LEN(B9)-C9)))"]
[null,"106AC",2,106,"=VALUE(LEFT(B10,(LEN(B10)-C10)))"]
[null,"107TV",2,107,"=VALUE(LEFT(B11,(LEN(B11)-C11)))"]
[null,"108Monitor",7,108,"=VALUE(LEFT(B12,(LEN(B12)-C12)))"]
[null,"109AC",2,109,"=VALUE(LEFT(B13,(LEN(B13)-C13)))"]
[null,"110TV",2,110,"=VALUE(LEFT(B14,(LEN(B14)-C14)))"]
[null,"111Monitor",7,111,"=VALUE(LEFT(B15,(LEN(B15)-C15)))"]

{"sheet":"MID","index":11,"n_rows":15,"n_cols":5,"rows_kept":15,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Use of MID Function"]
[]
[null,"Order ID","Name of Orderer","Last Name?","Formula"]
[null,101,"Morris Johnson",{"$f":"MID(C5,SEARCH(\" \",C5)+1,LEN(C5)-SEARCH(\" \",C5))","v":"Johnson"},{"$f":"_xlfn.FORMULATEXT(D5)","v":"=MID(C5,SEARCH(\" \",C5)+1,LEN(C5)-SEARCH(\" \",C5))"}]
[null,102,"Steve Smith",{"$f":"MID(C6,SEARCH(\" \",C6)+1,LEN(C6)-SEARCH(\" \",C6))","v":"Smith"},{"$f":"_xlfn.FORMULATEXT(D6)","v":"=MID(C6,SEARCH(\" \",C6)+1,LEN(C6)-SEARCH(\" \",C6))"}]
[null,103,"Alfred Moyes","Moyes","=MID(C7,SEARCH(\" \",C7)+1,LEN(C7)-SEARCH(\" \",C7))"]
[null,104,"Gregory Thomson","Thomson","=MID(C8,SEARCH(\" \",C8)+1,LEN(C8)-SEARCH(\" \",C8))"]
[null,105,"Angela Martyn","Martyn","=MID(C9,SEARCH(\" \",C9)+1,LEN(C9)-SEARCH(\" \",C9))"]
[null,106,"Ryan Harris","Harris","=MID(C10,SEARCH(\" \",C10)+1,LEN(C10)-SEARCH(\" \",C10))"]
[null,107,"Matthew Marsh","Marsh","=MID(C11,SEARCH(\" \",C11)+1,LEN(C11)-SEARCH(\" \",C11))"]
[null,108,"Marcus North","North","=MID(C12,SEARCH(\" \",C12)+1,LEN(C12)-SEARCH(\" \",C12))"]
[null,109,"Stephen Hockley","Hockley","=MID(C13,SEARCH(\" \",C13)+1,LEN(C13)-SEARCH(\" \",C13))"]
[null,110,"Ricardo Benjamin","Benjamin","=MID(C14,SEARCH(\" \",C14)+1,LEN(C14)-SEARCH(\" \",C14))"]
[null,111,"Richard Moor","Moor","=MID(C15,SEARCH(\" \",C15)+1,LEN(C15)-SEARCH(\" \",C15))"]

{"sheet":"FIND","index":12,"n_rows":15,"n_cols":5,"rows_kept":15,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Use of FIND Function"]
[]
[null,"Order ID","Name of Orderer","Fast Name?","Formula"]
[null,101,"Morris Johnson",{"$f":"MID(C5,1,FIND(\" \",C5)-1)","v":"Morris"},{"$f":"_xlfn.FORMULATEXT(D5)","v":"=MID(C5,1,FIND(\" \",C5)-1)"}]
[null,102,"Steve Smith",{"$f":"MID(C6,1,FIND(\" \",C6)-1)","v":"Steve"},{"$f":"_xlfn.FORMULATEXT(D6)","v":"=MID(C6,1,FIND(\" \",C6)-1)"}]
[null,103,"Alfred Moyes","Alfred","=MID(C7,1,FIND(\" \",C7)-1)"]
[null,104,"Gregory Thomson","Gregory","=MID(C8,1,FIND(\" \",C8)-1)"]
[null,105,"Angela Martyn","Angela","=MID(C9,1,FIND(\" \",C9)-1)"]
[null,106,"Ryan Harris","Ryan","=MID(C10,1,FIND(\" \",C10)-1)"]
[null,107,"Matthew Marsh","Matthew","=MID(C11,1,FIND(\" \",C11)-1)"]
[null,108,"Marcus North","Marcus","=MID(C12,1,FIND(\" \",C12)-1)"]
[null,109,"Stephen Hockley","Stephen","=MID(C13,1,FIND(\" \",C13)-1)"]
[null,110,"Ricardo Benjamin","Ricardo","=MID(C14,1,FIND(\" \",C14)-1)"]
[null,111,"Richard Moor","Richard","=MID(C15,1,FIND(\" \",C15)-1)"]