{"text_format":"1","workbook":"xlsx","n_sheets":13,"sheets":["Ampersand Operator","CONCATENATE function","SUBSTITUTE function ","TEXTJOIN function","Using Cell Format","Sheet1 (6)","Sheet1 (7)","Keyboard Shortcut","Comma style","Using VBA macro","Putting Comma in 3 digit","Practice for Yourself","Comma  between numbers"],"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":"Ampersand Operator","index":0,"n_rows":10,"n_cols":8,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,5,1,7]]}
[]
[null,"Adding Ampersand Operator",null,null,null,"Practice for Yourself"]
[]
[null,"Mobile","Price","Mobile, Price",null,"Mobile","Price","Mobile, Price"]
[null,"Iphone 14",1300,{"$f":"B5&\",\"&C5","v":"Iphone 14,1300"},null,"Iphone 14",1300,{"$f":"F5&\",\"&G5","v":"Iphone 14,1300"}]
[null,"Infinix Note 12",300,{"$f":"B6&\",\"&C6","v":"Infinix Note 12,300"},null,"Infinix Note 12",300,{"$f":"F6&\",\"&G6","v":"Infinix Note 12,300"}]
[null,"Mi 15",700,"Mi 15,700",null,"Mi 15",700,"Mi 15,700"]
[null,"Samsung Galaxy",650,"Samsung Galaxy,650",null,"Samsung Galaxy",650,"Samsung Galaxy,650"]
[null,"LG",500,"LG,500",null,"LG",500,"LG,500"]
[null,"Motorola Razr 40",759,"Motorola Razr 40,759",null,"Motorola Razr 40",759,"Motorola Razr 40,759"]

{"sheet":"CONCATENATE function","index":1,"n_rows":10,"n_cols":8,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,5,1,7]]}
[]
[null,"Using CONCATENATE Function",null,null,null,"Practice For Yourself"]
[]
[null,"Mobile","Price","Mobile,Price",null,"Mobile","Price","Mobile,Price"]
[null,"Iphone 14",1300,{"$f":"CONCATENATE(B5, \",\",C5)","v":"Iphone 14,1300"},null,"Iphone 14",1300]
[null,"Infinix Note 12",300,{"$f":"CONCATENATE(B6, \",\",C6)","v":"Infinix Note 12,300"},null,"Infinix Note 12",300]
[null,"Mi 15",700,"Mi 15,700",null,"Mi 15",700]
[null,"Samsung Galaxy",650,"Samsung Galaxy,650",null,"Samsung Galaxy",650]
[null,"LG",500,"LG,500",null,"LG",500]
[null,"Motorola Razr 40",759,"Motorola Razr 40,759",null,"Motorola Razr 40",759]

{"sheet":"SUBSTITUTE function ","index":2,"n_rows":10,"n_cols":10,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,4],[1,6,1,9]]}
[]
[null,"Using SUBSTITUTE Function",null,null,null,null,"Practice for Yourself"]
[]
[null,"Mobile","Price","Mobile-Price","Mobile, Price",null,"Mobile","Price","Mobile-Price","Mobile, Price"]
[null,"Iphone 14",1300,{"$f":"CONCATENATE(B5, \"-\",C5)","v":"Iphone 14-1300"},{"$f":"SUBSTITUTE(D5,\"-\",\",\")","v":"Iphone 14,1300"},null,"Iphone 14",1300,{"$f":"CONCATENATE(G5, \"-\",H5)","v":"Iphone 14-1300"}]
[null,"Infinix Note 12",300,{"$f":"CONCATENATE(B6, \"-\",C6)","v":"Infinix Note 12-300"},{"$f":"SUBSTITUTE(D6,\"-\",\",\")","v":"Infinix Note 12,300"},null,"Infinix Note 12",300,{"$f":"CONCATENATE(G6, \"-\",H6)","v":"Infinix Note 12-300"}]
[null,"Mi 15",700,"Mi 15-700","Mi 15,700",null,"Mi 15",700,"Mi 15-700"]
[null,"Samsung Galaxy",650,"Samsung Galaxy-650","Samsung Galaxy,650",null,"Samsung Galaxy",650,"Samsung Galaxy-650"]
[null,"LG",500,"LG-500","LG,500",null,"LG",500,"LG-500"]
[null,"Motorola Razr 40",759,"Motorola Razr 40-759","Motorola Razr 40,759",null,"Motorola Razr 40",759,"Motorola Razr 40-759"]

{"sheet":"TEXTJOIN function","index":3,"n_rows":10,"n_cols":8,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,5,1,7]]}
[]
[null,"Applying TEXTJOIN Function",null,null,null,"Practice for Yourself"]
[]
[null,"Mobile","Price","Mobile, Price",null,"Mobile","Price","Mobile, Price"]
[null,"Iphone 14",1300,{"$f":"_xlfn.TEXTJOIN(\",\",TRUE,B5,C5)","v":"Iphone 14,1300"},null,"Iphone 14",1300]
[null,"Infinix Note 12",300,{"$f":"_xlfn.TEXTJOIN(\",\",TRUE,B6,C6)","v":"Infinix Note 12,300"},null,"Infinix Note 12",300]
[null,"Mi 15",700,"Mi 15,700",null,"Mi 15",700]
[null,"Samsung Galaxy",650,"Samsung Galaxy,650",null,"Samsung Galaxy",650]
[null,"LG",500,"LG,500",null,"LG",500]
[null,"Motorola Razr 40",759,"Motorola Razr 40,759",null,"Motorola Razr 40",759]

{"sheet":"Using Cell Format","index":4,"n_rows":10,"n_cols":10,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,4],[1,6,1,9]]}
[]
[null,"Using Format Cells Option",null,null,null,null,"Practice for Yourself"]
[]
[null,"Mobile","Price","Sales Quantity","Total Sales ",null,"Mobile","Price","Sales Quantity","Total Sales "]
[null,"Iphone 14",900,900,{"$f":"D5*C5","v":810000},null,"Iphone 14",900,900,{"$f":"I5*H5","v":810000}]
[null,"Infinix Note 12",300,344,{"$f":"D6*C6","v":103200},null,"Infinix Note 12",300,344,{"$f":"I6*H6","v":103200}]
[null,"Mi 15",700,400,280000,null,"Mi 15",700,400,280000]
[null,"Samsung Galaxy",650,400,260000,null,"Samsung Galaxy",650,400,260000]
[null,"LG",500,499,249500,null,"LG",500,499,249500]
[null,"Motorola Razr 40",759,140,106260,null,"Motorola Razr 40",759,140,106260]

{"sheet":"Sheet1 (6)","index":5,"n_rows":10,"n_cols":10,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,4],[1,6,1,9]]}
[]
[null,"Applying FIXED Function",null,null,null,null,"Practice for Yourself"]
[]
[null,"Mobile","Price","Sales Quantity","Total Sales ",null,"Mobile","Price","Sales Quantity","Total Sales "]
[null,"Iphone 14",900,900,{"$f":"FIXED(D5*C5,0)","v":"810,000"},null,"Iphone 14",900,900]
[null,"Infinix Note 12",300,344,{"$f":"FIXED(D6*C6,0)","v":"103,200"},null,"Infinix Note 12",300,344]
[null,"Mi 15",700,400,"280,000",null,"Mi 15",700,400]
[null,"Samsung Galaxy",650,400,"260,000",null,"Samsung Galaxy",650,400]
[null,"LG",500,499,"249,500",null,"LG",500,499]
[null,"Motorola Razr 40",759,140,"106,260",null,"Motorola Razr 40",759,140]

{"sheet":"Sheet1 (7)","index":6,"n_rows":10,"n_cols":10,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,4],[1,6,1,9]]}
[]
[null,"Using Accounting Number Format",null,null,null,null,"Practice By Yourself"]
[]
[null,"Mobile","Price","Sales Quantity","Total Sales ",null,"Mobile","Price","Sales Quantity","Total Sales "]
[null,"Iphone 14",900,900,{"$f":"D5*C5","v":810000},null,"Iphone 14",900,900]
[null,"Infinix Note 12",300,344,{"$f":"D6*C6","v":103200},null,"Infinix Note 12",300,344]
[null,"Mi 15",700,400,280000,null,"Mi 15",700,400]
[null,"Samsung Galaxy",650,400,260000,null,"Samsung Galaxy",650,400]
[null,"LG",500,499,249500,null,"LG",500,499]
[null,"Motorola Razr 40",759,140,106260,null,"Motorola Razr 40",759,140]

{"sheet":"Keyboard Shortcut","index":7,"n_rows":10,"n_cols":10,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,4],[1,6,1,9]]}
[]
[null,"Using Keyboard Shortcut",null,null,null,null,"Practice for Yourself"]
[]
[null,"Mobile","Price","Sales Quantity","Total Sales ",null,"Mobile","Price","Sales Quantity","Total Sales "]
[null,"Iphone 14",900,900,{"$f":"D5*C5","v":810000},null,"Iphone 14",900,900]
[null,"Infinix Note 12",300,344,{"$f":"D6*C6","v":103200},null,"Infinix Note 12",300,344]
[null,"Mi 15",700,400,280000,null,"Mi 15",700,400]
[null,"Samsung Galaxy",650,400,260000,null,"Samsung Galaxy",650,400]
[null,"LG",500,499,249500,null,"LG",500,499]
[null,"Motorola Razr 40",759,140,106260,null,"Motorola Razr 40",759,140]

{"sheet":"Comma style","index":8,"n_rows":10,"n_cols":10,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,4],[1,6,1,9]]}
[]
[null,"Applying Comma Style",null,null,null,null,"Practice for Yourself"]
[]
[null,"Mobile","Price","Sales Quantity","Total Sales ",null,"Mobile","Price","Sales Quantity","Total Sales "]
[null,"Iphone 14",900,900,{"$f":"D5*C5","v":810000},null,"Iphone 14",900,900,{"$f":"I5*H5","v":810000}]
[null,"Infinix Note 12",300,344,{"$f":"D6*C6","v":103200},null,"Infinix Note 12",300,344,{"$f":"I6*H6","v":103200}]
[null,"Mi 15",700,400,280000,null,"Mi 15",700,400,280000]
[null,"Samsung Galaxy",650,400,260000,null,"Samsung Galaxy",650,400,260000]
[null,"LG",500,499,249500,null,"LG",500,499,249500]
[null,"Motorola Razr 40",759,140,106260,null,"Motorola Razr 40",759,140,106260]

{"sheet":"Using VBA macro","index":9,"n_rows":10,"n_cols":8,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,5,1,7]]}
[]
[null,"Using VBA Macro",null,null,null,"Practice for Yourself"]
[]
[null,"Mobile","Price","Mobile,Price",null,"Mobile","Price","Mobile,Price"]
[null,"Iphone 14",1300,"Iphone 14,1300",null,"Iphone 14",1300,"Iphone 14,1300"]
[null,"Infinix Note 12",300,"Infinix Note 12,300",null,"Infinix Note 12",300,"Infinix Note 12,300"]
[null,"Mi 15",700,"Mi 15,700",null,"Mi 15",700,"Mi 15,700"]
[null,"Samsung Galaxy",650,"Samsung Galaxy,650",null,"Samsung Galaxy",650,"Samsung Galaxy,650"]
[null,"LG",500,"LG,500",null,"LG",500,"LG,500"]
[null,"Motorola Razr 40",759,"Motorola Razr 40,759",null,"Motorola Razr 40",759,"Motorola Razr 40,759"]

{"sheet":"Putting Comma in 3 digit","index":10,"n_rows":10,"n_cols":10,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,4],[1,6,1,9]]}
[]
[null,"Putting Comma After 3 Digits",null,null,null,null,"Practice for Yourself"]
[]
[null,"Mobile","Price","Sales Quantity","Total Sales ",null,"Mobile","Price","Sales Quantity","Total Sales "]
[null,"Iphone 14",900,900,{"$f":"D5*C5","v":810000},null,"Iphone 14",900,900,{"$f":"I5*H5","v":810000}]
[null,"Infinix Note 12",300,344,{"$f":"D6*C6","v":103200},null,"Infinix Note 12",300,344,{"$f":"I6*H6","v":103200}]
[null,"Mi 15",700,400,280000,null,"Mi 15",700,400,280000]
[null,"Samsung Galaxy",650,400,260000,null,"Samsung Galaxy",650,400,260000]
[null,"LG",500,499,249500,null,"LG",500,499,249500]
[null,"Motorola Razr 40",759,140,106260,null,"Motorola Razr 40",759,140,106260]

{"sheet":"Practice for Yourself","index":11,"n_rows":8,"n_cols":6,"rows_kept":8,"cut":false,"hidden":false,"merged":[[1,4,1,5],[1,1,1,2]]}
[]
[null,"Adding Commas Between Names",null,null,"Practice for Yourself"]
[]
[null,"Names","Output",null,"Names","Output"]
[null,"Eri Emmuel Kent","Eri,Emmuel,Kent",null,"Eri Emmuel Kent","Eri,Emmuel,Kent"]
[null,"Bruce Constantine Lucy","Bruce,Constantine,Lucy",null,"Bruce Constantine Lucy","Bruce,Constantine,Lucy"]
[null,"Clark David Wayne","Clark,David,Wayne",null,"Clark David Wayne","Clark,David,Wayne"]
[null,"Gary Evan Lucy","Gary,Evan,Lucy",null,"Gary Evan Lucy","Gary,Evan,Lucy"]

{"sheet":"Comma  between numbers","index":12,"n_rows":10,"n_cols":8,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,5,1,7]]}
[]
[null,"Adding Comma Between Numbers",null,null,null,"Practice for Yourself"]
[]
[null,"Mobile","Sales Quantity","Adding Comma Between Numbers",null,"Mobile","Sales Quantity","Adding Comma Between Numbers"]
[null,"Iphone 14",879999344,{"$f":"LEFT(C5,3)&\",\"&MID(C5,4,3)&\",\"&RIGHT(C5,3)","v":"879,999,344"},null,"Iphone 14",879999344,{"$f":"LEFT(G5,3)&\",\"&MID(G5,4,3)&\",\"&RIGHT(G5,3)","v":"879,999,344"}]
[null,"Infinix Note 12",699998990,{"$f":"LEFT(C6,3)&\",\"&MID(C6,4,3)&\",\"&RIGHT(C6,3)","v":"699,998,990"},null,"Infinix Note 12",699998990,{"$f":"LEFT(G6,3)&\",\"&MID(G6,4,3)&\",\"&RIGHT(G6,3)","v":"699,998,990"}]
[null,"Mi 15",349599599,"349,599,599",null,"Mi 15",349599599,"349,599,599"]
[null,"Samsung Galaxy",284456734,"284,456,734",null,"Samsung Galaxy",284456734,"284,456,734"]
[null,"LG",256599945,"256,599,945",null,"LG",256599945,"256,599,945"]
[null,"Motorola Razr 40",225899933,"225,899,933",null,"Motorola Razr 40",225899933,"225,899,933"]