{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Dataset","Using Custom Format","Combined Formulas","VBA","Practice Section"],"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":10,"n_cols":3,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Phone Number Format with Extension"]
[]
[null,"Name","Phone"]
[null,"Adam Smith",10134567890]
[null,"Krissy Jhon",10124455678]
[null,"Scarlett Beck",80194567590]
[null,"Monica Will",70554367890]
[null,"Dulcy Gib",11178903456]
[null,"Andrew Ju",10121345670]

{"sheet":"Using Custom Format","index":1,"n_rows":10,"n_cols":5,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Use of Custom Format \n"]
[]
[null,"Name","Phone",null,{"$f":"LEN(C5)","v":12}]
[null,"Adam Smith",101345678923]
[null,"Krissy Jhon",101244556789]
[null,"Scarlett Beck",801945675572]
[null,"Monica Will",705543678431]
[null,"Dulcy Gib",111789034568]
[null,"Andrew Ju",101213456702]

{"sheet":"Combined Formulas","index":2,"n_rows":12,"n_cols":14,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Use of LEN, LEFT & MID Functions ",null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"(\"&LEFT(C6,3)&\") \"&MID(C6,4,3)&\"-\"&MID(C6,7,4)&\" ext \"&MID(C6,11,LEN(C6)-10)","v":"(101) 244-5567 ext 100"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"(\"&LEFT(C7,3)&\") \"&MID(C7,4,3)&\"-\"&MID(C7,7,4)&\" ext \"&MID(C7,11,LEN(C7)-10)","v":"(801) 945-6755 ext 7"}]
[null,"Name","Phone Number","Phone Number with Ext.",null,null,null,null,null,null,null,null,null,{"$f":"\"(\"&LEFT(C8,3)&\") \"&MID(C8,4,3)&\"-\"&MID(C8,7,4)&\" ext \"&MID(C8,11,LEN(C8)-10)","v":"(705) 543-6784 ext 22"}]
[null,"Adam Smith",101345678923,{"$f":"\"(\"&LEFT(C5,3)&\") \"&MID(C5,4,3)&\"-\"&MID(C5,7,4)&\" ext \"&MID(C5,11,LEN(C5)-10)","v":"(101) 345-6789 ext 23"},null,null,null,null,null,null,null,null,null,{"$f":"\"(\"&LEFT(C9,3)&\") \"&MID(C9,4,3)&\"-\"&MID(C9,7,4)&\" ext \"&MID(C9,11,LEN(C9)-10)","v":"(111) 789-0345 ext "}]
[null,"Krissy Jhon",1012445567100,{"$f":"\"(\"&LEFT(C6,3)&\") \"&MID(C6,4,3)&\"-\"&MID(C6,7,4)&\" ext \"&MID(C6,11,LEN(C6)-10)","v":"(101) 244-5567 ext 100"},null,null,null,null,null,null,null,null,null,{"$f":"\"(\"&LEFT(C10,3)&\") \"&MID(C10,4,3)&\"-\"&MID(C10,7,4)&\" ext \"&MID(C10,11,LEN(C10)-10)","v":"(101) 213-4567 ext 02"}]
[null,"Scarlett Beck",80194567557,"(801) 945-6755 ext 7",null,null,null,null,{"$f":"LEN(C5)","v":12},null,10134567890,{"$f":"\"(\"&LEFT(C5,3)&\") \"&MID(C5,4,3)&\"-\"&MID(C5,7,4)&\" ext \"&MID(C5,10,2)","v":"(101) 345-6789 ext 92"}]
[null,"Monica Will",705543678422,"(705) 543-6784 ext 22",null,null,null,null,13,null,10124455678,"(101) 244-5567 ext 71"]
[null,"Dulcy Gib",1117890345,"(111) 789-0345 ext ",null,null,null,null,11,null,80194567590,"(801) 945-6755 ext 57"]
[null,"Andrew Ju",101213456702,"(101) 213-4567 ext 02",null,null,null,null,12,null,70554367890,"(705) 543-6784 ext 42"]
[null,null,null,null,null,null,null,null,10,null,11178903456,"(111) 789-0345 ext 5"]
[null,null,null,null,null,null,null,null,12,null,10121345670,"(101) 213-4567 ext 70"]

{"sheet":"VBA","index":3,"n_rows":7,"n_cols":3,"rows_kept":7,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Use of VBA"]
[]
[null,"Name","Phone"]
[null,"Adam Smith","(123) 456-ext78"]
[null,"Krissy Jhon","(123) 4567-ext890"]
[null,"Scarlett Beck","(123) 456-7890-ext12"]

{"sheet":"Practice Section","index":4,"n_rows":10,"n_cols":4,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Do it YourSelf"]
[]
[null,"Name","Phone","Phone # with Ext"]
[null,"Adam Smith",10134567890]
[null,"Krissy Jhon",10124455678]
[null,"Scarlett Beck",80194567590]
[null,"Monica Will",70554367890]
[null,"Dulcy Gib",11178903456]
[null,"Andrew Ju",10121345670]