{"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":3,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Use of Custom Format \n"]
[]
[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":"Combined Formulas","index":2,"n_rows":10,"n_cols":4,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Use of LEFT & MID Functions "]
[]
[null,"Name","Phone","Phone # with Ext"]
[null,"Adam Smith",10134567896,{"$f":"\"(\"&LEFT(C5,3)&\")\"&MID(C5,4,3)&\"-\"&MID(C5,7,4)&\" ext\"&MID(C5,11,99)","v":"(101)345-6789 ext6"}]
[null,"Krissy Jhon",101244556782,{"$f":"\"(\"&LEFT(C6,3)&\")\"&MID(C6,4,3)&\"-\"&MID(C6,7,4)&\" ext\"&MID(C6,11,99)","v":"(101)244-5567 ext82"}]
[null,"Scarlett Beck",8019456759101,{"$f":"\"(\"&LEFT(C7,3)&\")\"&MID(C7,4,3)&\"-\"&MID(C7,7,4)&\" ext\"&MID(C7,11,99)","v":"(801)945-6759 ext101"}]
[null,"Monica Will",705543678920,"(705)543-6789 ext20"]
[null,"Dulcy Gib",11178903456,"(111)789-0345 ext6"]
[null,"Andrew Ju",1012134567041,"(101)213-4567 ext041"]

{"sheet":"VBA","index":3,"n_rows":6,"n_cols":2,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
["(456) 678-ext32"]
["(654) 789-ext12"]
["(234) 4325-ext432"]
["(345) 6654-ext321","It will format each 8, 10 & 12 digit number "]
["(345) 678-9012-ext234"]
["(234) 432-5432-ext212"]

{"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]