{"text_format":"1","workbook":"xlsx","n_sheets":10,"sheets":["Dataset","LEFT & MID","LEFT, RIGHT & LEN","Format Cells","Comma Style","Text ","MID","LEFT, RIGHT & MID","Currency","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":"Dataset","index":0,"n_rows":9,"n_cols":3,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Put Comma After 2 Digits"]
[]
[null,"Product ","Quantity"]
[null,"Wing Chair",20056]
[null,"Armchair",30450]
[null,"Sofa",22000]
[null,"Desk Chair",40435]
[null,"Club Chair",23435]

{"sheet":"LEFT & MID","index":1,"n_rows":9,"n_cols":14,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,11,1,13]]}
[]
[null,"Use of LEFT & MID Functions",null,null,null,null,null,null,null,null,null,"Do It Yourself"]
[]
[null,"Product ","Quantity","Add Comma",null,null,null,null,null,null,null,"Product ","Quantity","Add Comma"]
[null,"Wing Chair",20056,{"$f":"LEFT(C5,2)&\",\"&MID(C5,3,10)","v":"20,056"},null,null,null,null,null,null,null,"Wing Chair",20056]
[null,"Armchair",304505,{"$f":"LEFT(C6,2)&\",\"&MID(C6,3,10)","v":"30,4505"},null,null,null,null,null,null,null,"Armchair",304505]
[null,"Sofa",22000,"22,000",null,null,null,null,null,null,null,"Sofa",22000]
[null,"Desk Chair",540435,"54,0435",null,null,null,null,null,null,null,"Desk Chair",540435]
[null,"Club Chair",23435,"23,435",null,null,null,null,null,null,null,"Club Chair",23435]

{"sheet":"LEFT, RIGHT & LEN","index":2,"n_rows":9,"n_cols":14,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,11,1,13]]}
[]
[null,"Use of LEFT, RIGHT & LEN Functions",null,null,null,null,null,null,null,null,null,"Do It Yourself"]
[]
[null,"Product ","Quantity","Add Comma",null,null,null,null,null,null,null,"Product ","Quantity","Add Comma"]
[null,"Wing Chair",20056,{"$f":"LEFT(C5,2)&\",\"&RIGHT(C5,LEN(C5)-2)","v":"20,056"},null,null,null,null,null,null,null,"Wing Chair",20056]
[null,"Armchair",304505,{"$f":"LEFT(C6,2)&\",\"&RIGHT(C6,LEN(C6)-2)","v":"30,4505"},null,null,null,null,null,null,null,"Armchair",304505]
[null,"Sofa",22000,"22,000",null,null,null,null,null,null,null,"Sofa",22000]
[null,"Desk Chair",540435,"54,0435",null,null,null,null,null,null,null,"Desk Chair",540435]
[null,"Club Chair",23435,"23,435",null,null,null,null,null,null,null,"Club Chair",23435]

{"sheet":"Format Cells","index":3,"n_rows":17,"n_cols":13,"rows_kept":17,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,11,1,12]]}
[]
[null,"Use of Format Cells ",null,null,null,null,null,null,null,null,null,"Do It Yourself"]
[]
[null,"Product ","Quantity",null,null,null,null,null,null,null,null,"Product ","Quantity"]
[null,"Wing Chair",20056,null,null,null,null,null,null,null,null,"Wing Chair",20056]
[null,"Armchair",30450,null,null,null,null,null,null,null,null,"Armchair",304505]
[null,"Sofa",22000,null,null,null,null,null,null,null,null,"Sofa",22000]
[null,"Desk Chair",54043,null,null,null,null,null,null,null,null,"Desk Chair",540435]
[null,"Club Chair",23435,null,null,null,null,null,null,null,null,"Club Chair",23435]
[]
[]
[null,"Product ","Quantity"]
[null,"Wing Chair",20056]
[null,"Armchair",304505]
[null,"Sofa",22000]
[null,"Desk Chair",5404345]
[null,"Club Chair",23435]

{"sheet":"Comma Style","index":4,"n_rows":9,"n_cols":13,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,10,1,12]]}
[]
[null,"Use of Comma Style",null,null,null,null,null,null,null,null,"Do It Yourself"]
[]
[null,"Product ","Quantity",null,null,null,null,null,null,null,"Product ","Quantity","Add Comma"]
[null,"Wing Chair",20056,null,null,null,null,null,null,null,"Wing Chair",20056]
[null,"Armchair",30450,null,null,null,null,null,null,null,"Armchair",30450]
[null,"Sofa",22000,null,null,null,null,null,null,null,"Sofa",22000]
[null,"Desk Chair",54043,null,null,null,null,null,null,null,"Desk Chair",54043]
[null,"Club Chair",23435,null,null,null,null,null,null,null,"Club Chair",23435]

{"sheet":"Text ","index":5,"n_rows":9,"n_cols":14,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,11,1,13]]}
[]
[null,"Use of Text Function",null,null,null,null,null,null,null,null,null,"Do It Yourself"]
[]
[null,"Product ","Quantity","Add Comma",null,null,null,null,null,null,null,"Product ","Quantity","Add Comma"]
[null,"Wing Chair",20056,{"$f":"TEXT(C5,\"0\"\",\"\"000\")","v":"20,056"},null,null,null,null,null,null,null,"Wing Chair",20056]
[null,"Armchair",304505,{"$f":"TEXT(C6,\"0\"\",\"\"0000\")","v":"30,4505"},null,null,null,null,null,null,null,"Armchair",304505]
[null,"Sofa",22000,{"$f":"TEXT(C7,\"0\"\",\"\"000\")","v":"22,000"},null,null,null,null,null,null,null,"Sofa",22000]
[null,"Desk Chair",540435,{"$f":"TEXT(C8,\"0\"\",\"\"0000\")","v":"54,0435"},null,null,null,null,null,null,null,"Desk Chair",540435]
[null,"Club Chair",23435,"23,435",null,null,null,null,null,null,null,"Club Chair",23435]

{"sheet":"MID","index":6,"n_rows":9,"n_cols":14,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,11,1,13]]}
[]
[null,"Use of MID Function with Ampersand (&)",null,null,null,null,null,null,null,null,null,"Do It Yourself"]
[]
[null,"Product ","Quantity","Add Comma",null,null,null,null,null,null,null,"Product ","Quantity","Add Comma"]
[null,"Wing Chair",20056,{"$f":"MID(C5,1,2)&\",\"&MID(C5,3,6)","v":"20,056"},null,null,null,null,null,null,null,"Wing Chair",20056]
[null,"Armchair",304505,{"$f":"MID(C6,1,2)&\",\"&MID(C6,3,6)","v":"30,4505"},null,null,null,null,null,null,null,"Armchair",304505]
[null,"Sofa",22000,"22,000",null,null,null,null,null,null,null,"Sofa",22000]
[null,"Desk Chair",540435,"54,0435",null,null,null,null,null,null,null,"Desk Chair",540435]
[null,"Club Chair",23435,"23,435",null,null,null,null,null,null,null,"Club Chair",23435]

{"sheet":"LEFT, RIGHT & MID","index":7,"n_rows":9,"n_cols":14,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,11,1,13]]}
[]
[null,"Use of LEFT, MID & RIGHT Functions",null,null,null,null,null,null,null,null,null,"Do It Yourself"]
[]
[null,"Product ","Quantity","Add Comma",null,null,null,null,null,null,null,"Product ","Quantity","Add Comma"]
[null,"Wing Chair",20056,{"$f":"LEFT(C5,2) &\",\"&MID(C5,3,1)&RIGHT(C5,2)","v":"20,056"},null,null,null,null,null,null,null,"Wing Chair",200565]
[null,"Armchair",304505,{"$f":"LEFT(C6,2) &\",\"&MID(C6,3,2)&RIGHT(C6,2)","v":"30,4505"},null,null,null,null,null,null,null,"Armchair",304505]
[null,"Sofa",220006,"22,0006",null,null,null,null,null,null,null,"Sofa",220006]
[null,"Desk Chair",540435,"54,0435",null,null,null,null,null,null,null,"Desk Chair",540435]
[null,"Club Chair",234352,"23,4352",null,null,null,null,null,null,null,"Club Chair",234352]

{"sheet":"Currency","index":8,"n_rows":9,"n_cols":13,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,10,1,12]]}
[]
[null,"Use of Currency Feature",null,null,null,null,null,null,null,null,"Do It Yourself"]
[]
[null,"Product ","Sales",null,null,null,null,null,null,null,"Product ","Sales","Add Comma"]
[null,"Wing Chair",20056,null,null,null,null,null,null,null,"Wing Chair",20056]
[null,"Armchair",30450,null,null,null,null,null,null,null,"Armchair",30450]
[null,"Sofa",22000,null,null,null,null,null,null,null,"Sofa",22000]
[null,"Desk Chair",54043,null,null,null,null,null,null,null,"Desk Chair",54043]
[null,"Club Chair",23435,null,null,null,null,null,null,null,"Club Chair",23435]

{"sheet":"VBA","index":9,"n_rows":9,"n_cols":13,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,10,1,12]]}
[]
[null,"Use of VBA Code",null,null,null,null,null,null,null,null,"Do It Yourself"]
[]
[null,"Product ","Quantity",null,null,null,null,null,null,null,"Product ","Quantity","Add Comma"]
[null,"Wing Chair",20056,null,null,null,null,null,null,null,"Wing Chair",20056]
[null,"Armchair",3045055,null,null,null,null,null,null,null,"Armchair",3045055]
[null,"Sofa",220006,null,null,null,null,null,null,null,"Sofa",220006]
[null,"Desk Chair",404355,null,null,null,null,null,null,null,"Desk Chair",404355]
[null,"Club Chair",234352,null,null,null,null,null,null,null,"Club Chair",234352]