{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Dataset","custom","special","Replace","TEXT","LEFT. MID, RIGHT","VBA","dash between texts"],"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":14,"n_cols":4,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Contact List of Hotel California"]
[]
[null,"Name","Designation","Phone Number"]
[null,"Ned Stark","CEO",9083564879]
[null,"Robert Baratheon","CFO",8783564889]
[null,"Daenerys Targaryn","CBO",4893564890]
[null,"Jaime Lannister","COO",1063564888]
[null,"Jon Snow","Manager (Operation)",6283563700]
[null,"Samwell Tarly","Manager (Sales)",8803502567]
[null,"Margaery Tyrell","Manager (Supply Chain)",7783569971]
[null,"Jorah Mormont","Manager (HR)",9983566850]
[null,"Theon Grejoy","Manager (Finance)",1183565877]
[null,"Total"]

{"sheet":"custom","index":1,"n_rows":14,"n_cols":5,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Contact List of Hotel California"]
[]
[null,"Name","Designation","Phone Number","Formatted"]
[null,"Ned Stark","CEO",9083564879,9083564879]
[null,"Robert Baratheon","CFO",8783564889,8783564889]
[null,"Daenerys Targaryn","CBO",4893564890,4893564890]
[null,"Jaime Lannister","COO",1063564888,1063564888]
[null,"Jon Snow","Manager (Operation)",6283563700,6283563700]
[null,"Samwell Tarly","Manager (Sales)",8803502567,8803502567]
[null,"Margaery Tyrell","Manager (Supply Chain)",7783569971,7783569971]
[null,"Jorah Mormont","Manager (HR)",9983566850,9983566850]
[null,"Theon Grejoy","Manager (Finance)",1183565877,1183565877]
[null,"Total"]

{"sheet":"special","index":2,"n_rows":14,"n_cols":5,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Contact List of Hotel California"]
[]
[null,"Name","Designation","Phone Number","Formatted"]
[null,"Ned Stark","CEO",9083564879,9083564879]
[null,"Robert Baratheon","CFO",8783564889,8783564889]
[null,"Daenerys Targaryn","CBO",4893564890,4893564890]
[null,"Jaime Lannister","COO",1063564888,1063564888]
[null,"Jon Snow","Manager (Operation)",6283563700,6283563700]
[null,"Samwell Tarly","Manager (Sales)",8803502567,8803502567]
[null,"Margaery Tyrell","Manager (Supply Chain)",7783569971,7783569971]
[null,"Jorah Mormont","Manager (HR)",9983566850,9983566850]
[null,"Theon Grejoy","Manager (Finance)",1183565877,1183565877]
[null,"Total"]

{"sheet":"Replace","index":3,"n_rows":14,"n_cols":5,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Contact List of Hotel California"]
[]
[null,"Name","Designation","Phone Number","Formatted"]
[null,"Ned Stark","CEO",9083564879,{"$f":"REPLACE(REPLACE(D5,4,0,\"-\"),8,0,\"-\")","v":"908-356-4879"}]
[null,"Robert Baratheon","CFO",8783564889]
[null,"Daenerys Targaryn","CBO",4893564890]
[null,"Jaime Lannister","COO",1063564888]
[null,"Jon Snow","Manager (Operation)",6283563700]
[null,"Samwell Tarly","Manager (Sales)",8803502567]
[null,"Margaery Tyrell","Manager (Supply Chain)",7783569971]
[null,"Jorah Mormont","Manager (HR)",9983566850]
[null,"Theon Grejoy","Manager (Finance)",1183565877]
[null,"Total"]

{"sheet":"TEXT","index":4,"n_rows":14,"n_cols":5,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Contact List of Hotel California"]
[]
[null,"Name","Designation","Phone Number","Formatted"]
[null,"Ned Stark","CEO",9083564879,{"$f":"TEXT(D5,\"???-???-????\")","v":"908-356-4879"}]
[null,"Robert Baratheon","CFO",8783564889]
[null,"Daenerys Targaryn","CBO",4893564890]
[null,"Jaime Lannister","COO",1063564888]
[null,"Jon Snow","Manager (Operation)",6283563700]
[null,"Samwell Tarly","Manager (Sales)",8803502567]
[null,"Margaery Tyrell","Manager (Supply Chain)",7783569971]
[null,"Jorah Mormont","Manager (HR)",9983566850]
[null,"Theon Grejoy","Manager (Finance)",1183565877]
[null,"Total"]

{"sheet":"LEFT. MID, RIGHT","index":5,"n_rows":14,"n_cols":5,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Contact List of Hotel California"]
[]
[null,"Name","Designation","Phone Number","Formatted"]
[null,"Ned Stark","CEO",9083564879,{"$f":"LEFT(D5,3)&\"-\"&MID(D5,4,3)&\"-\"&RIGHT(D5,4)","v":"908-356-4879"}]
[null,"Robert Baratheon","CFO",8783564889]
[null,"Daenerys Targaryn","CBO",4893564890]
[null,"Jaime Lannister","COO",1063564888]
[null,"Jon Snow","Manager (Operation)",6283563700]
[null,"Samwell Tarly","Manager (Sales)",8803502567]
[null,"Margaery Tyrell","Manager (Supply Chain)",7783569971]
[null,"Jorah Mormont","Manager (HR)",9983566850]
[null,"Theon Grejoy","Manager (Finance)",1183565877]
[null,"Total"]

{"sheet":"VBA","index":6,"n_rows":14,"n_cols":5,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Contact List of Hotel California"]
[]
[null,"Name","Designation","Phone Number","Formatted"]
[null,"Ned Stark","CEO",9083564879,9083564879]
[null,"Robert Baratheon","CFO",8783564889,8783564889]
[null,"Daenerys Targaryn","CBO",4893564890,4893564890]
[null,"Jaime Lannister","COO",1063564888,1063564888]
[null,"Jon Snow","Manager (Operation)",6283563700,6283563700]
[null,"Samwell Tarly","Manager (Sales)",8803502567,8803502567]
[null,"Margaery Tyrell","Manager (Supply Chain)",7783569971,7783569971]
[null,"Jorah Mormont","Manager (HR)",9983566850,9983566850]
[null,"Theon Grejoy","Manager (Finance)",1183565877,1183565877]
[null,"Total"]

{"sheet":"dash between texts","index":7,"n_rows":14,"n_cols":4,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Contact List of Hotel California"]
[]
[null,"Name","Designation","Phone Number"]
[null,"Ned-Stark","CEO",9083564879]
[null,"Robert-Baratheon","CFO",8783564889]
[null,"Daenerys-Targaryn","CBO",4893564890]
[null,"Jaime-Lannister","COO",1063564888]
[null,"Jon-Snow","Manager-(Operation)",6283563700]
[null,"Samwell-Tarly","Manager-(Sales)",8803502567]
[null,"Margaery-Tyrell","Manager-(Supply-Chain)",7783569971]
[null,"Jorah-Mormont","Manager-(HR)",9983566850]
[null,"Theon-Grejoy","Manager-(Finance)",1183565877]
[null,"Total"]