{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Dataset","Find and Replace","Text to Column ","SUBSTITUTE Function","INDIRECT Function","MID Function","VBA Macro Code"],"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":3,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Employee Name and Address"]
[null,"Name","Address"]
[null,"\"Jane Doe\"","\"New York\""]
[null,"\"Kit Harington\"","\"Boston\""]
[null,"\"Jane Austin\"","\"Philadelphia\""]
[null,"\"Julia Roberts\"","\"California\""]
[null,"\"Andrew Eric\"","\"Texas\""]
[null,"\"Bob Harly\"","\"Chicago\""]
[null,"\"Rocky Montana\"","\"Houston\""]
[null,"\"Jay Hope\"","\"San Diego\""]
[null,"\"Jony Wilson\"","\"Dallas\""]
[null,"\"John Walker\"","\"Seattle\""]
[null,"\"Pep Carlos\"","\"Denver\""]

{"sheet":"Find and Replace","index":1,"n_rows":14,"n_cols":3,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Using Find and Replace"]
[null,"Name","Address"]
[null,"Jane Doe","New York"]
[null,"Kit Harington","Boston"]
[null,"Jane Austin","Philadelphia"]
[null,"Julia Roberts","California"]
[null,"Andrew Eric","Texas"]
[null,"Bob Harly","Chicago"]
[null,"Rocky Montana","Houston"]
[null,"Jay Hope","San Diego"]
[null,"Jony Wilson","Dallas"]
[null,"John Walker","Seattle"]
[null,"Pep Carlos","Denver"]

{"sheet":"Text to Column ","index":2,"n_rows":14,"n_cols":3,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Using SUBSTITUTE Function"]
[null,"Name","Address"]
[null,"Jane Doe","New York"]
[null,"Kit Harington","Boston"]
[null,"Jane Austin","Philadelphia"]
[null,"Julia Roberts","California"]
[null,"Andrew Eric","Texas"]
[null,"Bob Harly","Chicago"]
[null,"Rocky Montana","Houston"]
[null,"Jay Hope","San Diego"]
[null,"Jony Wilson","Dallas"]
[null,"John Walker","Seattle"]
[null,"Pep Carlos","Denver"]

{"sheet":"SUBSTITUTE Function","index":3,"n_rows":14,"n_cols":5,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Using SUBSTITUTE Function"]
[null,"Name","Address","Quotation free Name","Quotation free Address"]
[null,"\"Jane Doe\"","\"New York\"",{"$f":"SUBSTITUTE(B4,CHAR(34),\"\")","v":"Jane Doe"},{"$f":"SUBSTITUTE(C4,CHAR(34),\"\")","v":"New York"}]
[null,"\"Kit Harington\"","\"Boston\"",{"$f":"SUBSTITUTE(B5,CHAR(34),\"\")","v":"Kit Harington"},{"$f":"SUBSTITUTE(C5,CHAR(34),\"\")","v":"Boston"}]
[null,"\"Jane Austin\"","\"Philadelphia\"","Jane Austin","Philadelphia"]
[null,"\"Julia Roberts\"","\"California\"","Julia Roberts","California"]
[null,"\"Andrew Eric\"","\"Texas\"","Andrew Eric","Texas"]
[null,"\"Bob Harly\"","\"Chicago\"","Bob Harly","Chicago"]
[null,"\"Rocky Montana\"","\"Houston\"","Rocky Montana","Houston"]
[null,"\"Jay Hope\"","\"San Diego\"","Jay Hope","San Diego"]
[null,"\"Jony Wilson\"","\"Dallas\"","Jony Wilson","Dallas"]
[null,"\"John Walker\"","\"Seattle\"","John Walker","Seattle"]
[null,"\"Pep Carlos\"","\"Denver\"","Pep Carlos","Denver"]

{"sheet":"INDIRECT Function","index":4,"n_rows":14,"n_cols":5,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Using INDIRECT Function"]
[null,"Name","Address","Quotation free Name","Quotation free Address"]
[null,{"$f":"\"Jane Doe\"","v":"Jane Doe"},{"$f":"\"New York\"","v":"New York"},{"$f":"INDIRECT(\"B4\")","v":"Jane Doe"},{"$f":"INDIRECT(\"C4\")","v":"New York"}]
[null,{"$f":"\"Kit Harington\"","v":"Kit Harington"},{"$f":"\"Boston\"","v":"Boston"},{"$f":"INDIRECT(\"B5\")","v":"Kit Harington"},{"$f":"INDIRECT(\"C5\")","v":"Boston"}]
[null,{"$f":"\"Jane Austin\"","v":"Jane Austin"},{"$f":"\"Philadelphia\"","v":"Philadelphia"},{"$f":"INDIRECT(\"B6\")","v":"Jane Austin"},{"$f":"INDIRECT(\"C6\")","v":"Philadelphia"}]
[null,{"$f":"\"Julia Roberts\"","v":"Julia Roberts"},{"$f":"\"California\"","v":"California"},{"$f":"INDIRECT(\"B6\")","v":"Jane Austin"},{"$f":"INDIRECT(\"C7\")","v":"California"}]
[null,{"$f":"\"Andrew Eric\"","v":"Andrew Eric"},{"$f":"\"Texas\"","v":"Texas"},{"$f":"INDIRECT(\"B8\")","v":"Andrew Eric"},{"$f":"INDIRECT(\"C8\")","v":"Texas"}]
[null,{"$f":"\"Bob Harly\"","v":"Bob Harly"},{"$f":"\"Chicago\"","v":"Chicago"},{"$f":"INDIRECT(\"B9\")","v":"Bob Harly"},{"$f":"INDIRECT(\"C9\")","v":"Chicago"}]
[null,{"$f":"\"Rocky Montana\"","v":"Rocky Montana"},{"$f":"\"Houston\"","v":"Houston"},{"$f":"INDIRECT(\"B10\")","v":"Rocky Montana"},{"$f":"INDIRECT(\"C10\")","v":"Houston"}]
[null,{"$f":"\"Jay Hope\"","v":"Jay Hope"},{"$f":"\"San Diego\"","v":"San Diego"},{"$f":"INDIRECT(\"B11\")","v":"Jay Hope"},{"$f":"INDIRECT(\"C11\")","v":"San Diego"}]
[null,{"$f":"\"Jony Wilson\"","v":"Jony Wilson"},{"$f":"\"Dallas\"","v":"Dallas"},{"$f":"INDIRECT(\"B12\")","v":"Jony Wilson"},{"$f":"INDIRECT(\"C12\")","v":"Dallas"}]
[null,{"$f":"\"John Walker\"","v":"John Walker"},{"$f":"\"Seattle\"","v":"Seattle"},{"$f":"INDIRECT(\"B13\")","v":"John Walker"},{"$f":"INDIRECT(\"C13\")","v":"Seattle"}]
[null,{"$f":"\"Pep Carlos\"","v":"Pep Carlos"},{"$f":"\"Denver\"","v":"Denver"},{"$f":"INDIRECT(\"B14\")","v":"Pep Carlos"},{"$f":"INDIRECT(\"C14\")","v":"Denver"}]

{"sheet":"MID Function","index":5,"n_rows":14,"n_cols":5,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Using MID Function"]
[null,"Name","Address","Quotation free Name","Quotation free Address"]
[null,"\"Jane Doe\"","\"New York\"",{"$f":"MID(B4,2,8)","v":"Jane Doe"},{"$f":"MID(C4,2,8)","v":"New York"}]
[null,"\"Kit Harington\"","\"Boston\"",{"$f":"MID(B5,2,13)","v":"Kit Harington"},{"$f":"MID(C5,2,6)","v":"Boston"}]
[null,"\"Jane Austin\"","\"Philadelphia\"",{"$f":"MID(B6,2,11)","v":"Jane Austin"},{"$f":"MID(C6,2,12)","v":"Philadelphia"}]
[null,"\"Julia Roberts\"","\"California\"",{"$f":"MID(B7,2,13)","v":"Julia Roberts"},{"$f":"MID(C7,2,10)","v":"California"}]
[null,"\"Andrew Eric\"","\"Texas\"",{"$f":"MID(B8,2,11)","v":"Andrew Eric"},{"$f":"MID(C8,2,5)","v":"Texas"}]
[null,"\"Bob Harly\"","\"Chicago\"",{"$f":"MID(B9,2,9)","v":"Bob Harly"},{"$f":"MID(C9,2,7)","v":"Chicago"}]
[null,"\"Rocky Montana\"","\"Houston\"",{"$f":"MID(B10,2,13)","v":"Rocky Montana"},{"$f":"MID(C10,2,7)","v":"Houston"}]
[null,"\"Jay Hope\"","\"San Diego\"",{"$f":"MID(B11,2,8)","v":"Jay Hope"},{"$f":"MID(C11,2,9)","v":"San Diego"}]
[null,"\"Jony Wilson\"","\"Dallas\"",{"$f":"MID(B12,2,11)","v":"Jony Wilson"},{"$f":"MID(C12,2,6)","v":"Dallas"}]
[null,"\"John Walker\"","\"Seattle\"",{"$f":"MID(B13,2,11)","v":"John Walker"},{"$f":"MID(C13,2,7)","v":"Seattle"}]
[null,"\"Pep Carlos\"","\"Denver\"",{"$f":"MID(B14,2,10)","v":"Pep Carlos"},{"$f":"MID(C14,2,6)","v":"Denver"}]

{"sheet":"VBA Macro Code","index":6,"n_rows":14,"n_cols":3,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Employee Name"]
[null,"Name","Address"]
[null," Jane Doe "," New York "]
[null," Kit Harington "," Boston "]
[null," Jane Austin "," Philadelphia "]
[null," Julia Roberts "," California "]
[null," Andrew Eric "," Texas "]
[null," Bob Harly "," Chicago "]
[null," Rocky Montana "," Houston "]
[null," Jay Hope "," San Diego "]
[null," Jony Wilson "," Dallas "]
[null," John Walker "," Seattle "]
[null," Pep Carlos "," Denver "]