{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Dataset","Use of Flash Fill Command","Using Ampersand Operator","Applying CONCATENATE Function","Using REPLACE Function","Use of SUBSTITUTE Function","Employing VBA","Comma Before 1st Text Character"],"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":12,"n_cols":3,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Adding Comma Before Text"]
[]
[null,"Student ID"," Name"]
[null,22001,"Adam"]
[null,22002,"Rachel"]
[null,22003,"Kim"]
[null,22004,"Stuart"]
[null,22005,"Jerry"]
[null,22006,"Alice"]
[null,22007,"Helen"]
[null,22008,"Fred"]

{"sheet":"Use of Flash Fill Command","index":1,"n_rows":12,"n_cols":11,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,8,1,10]]}
[]
[null,"Use of Flash Fill Command",null,null,null,null,null,null,"Do it Yourself"]
[]
[null,"Student ID"," Name"," Name with Comma",null,null,null,null,"Student ID"," Name"," Name with Comma"]
[null,22001,"Adam",",Adam",null,null,null,null,22001,"Adam"]
[null,22002,"Rachel",",Rachel",null,null,null,null,22002,"Rachel"]
[null,22003,"Kim",",Kim",null,null,null,null,22003,"Kim"]
[null,22004,"Stuart",",Stuart",null,null,null,null,22004,"Stuart"]
[null,22005,"Jerry",",Jerry",null,null,null,null,22005,"Jerry"]
[null,22006,"Alice",",Alice",null,null,null,null,22006,"Alice"]
[null,22007,"Helen",",Helen",null,null,null,null,22007,"Helen"]
[null,22008,"Fred",",Fred",null,null,null,null,22008,"Fred"]

{"sheet":"Using Ampersand Operator","index":2,"n_rows":12,"n_cols":11,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,8,1,10]]}
[]
[null,"Using Ampersand Operator",null,null,null,null,null,null,"Do it Yourself"]
[]
[null,"Student ID"," Name"," Name with Comma",null,null,null,null,"Student ID"," Name"," Name with Comma"]
[null,22001,"Adam",{"$f":"\",\"&C5","v":",Adam"},null,null,null,null,22001,"Adam"]
[null,22002,"Rachel",{"$f":"\",\"&C6","v":",Rachel"},null,null,null,null,22002,"Rachel"]
[null,22003,"Kim",",Kim",null,null,null,null,22003,"Kim"]
[null,22004,"Stuart",",Stuart",null,null,null,null,22004,"Stuart"]
[null,22005,"Jerry",",Jerry",null,null,null,null,22005,"Jerry"]
[null,22006,"Alice",",Alice",null,null,null,null,22006,"Alice"]
[null,22007,"Helen",",Helen",null,null,null,null,22007,"Helen"]
[null,22008,"Fred",",Fred",null,null,null,null,22008,"Fred"]

{"sheet":"Applying CONCATENATE Function","index":3,"n_rows":12,"n_cols":11,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,8,1,10]]}
[]
[null,"Applying CONCATENATE Function",null,null,null,null,null,null,"Do it Yourself"]
[]
[null,"Student ID"," Name"," Name with Comma",null,null,null,null,"Student ID"," Name"," Name with Comma"]
[null,22001,"Adam",{"$f":"CONCATENATE(\",\",C5)","v":",Adam"},null,null,null,null,22001,"Adam"]
[null,22002,"Rachel",{"$f":"CONCATENATE(\",\",C6)","v":",Rachel"},null,null,null,null,22002,"Rachel"]
[null,22003,"Kim",",Kim",null,null,null,null,22003,"Kim"]
[null,22004,"Stuart",",Stuart",null,null,null,null,22004,"Stuart"]
[null,22005,"Jerry",",Jerry",null,null,null,null,22005,"Jerry"]
[null,22006,"Alice",",Alice",null,null,null,null,22006,"Alice"]
[null,22007,"Helen",",Helen",null,null,null,null,22007,"Helen"]
[null,22008,"Fred",",Fred",null,null,null,null,22008,"Fred"]

{"sheet":"Using REPLACE Function","index":4,"n_rows":12,"n_cols":11,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,8,1,10]]}
[]
[null,"Using REPLACE Function",null,null,null,null,null,null,"Do it Yourself"]
[]
[null,"Student ID"," Name"," Name with Comma",null,null,null,null,"Student ID"," Name"," Name with Comma"]
[null,22001,"Adam",{"$f":"REPLACE(C5,1,0,\",\")","v":",Adam"},null,null,null,null,22001,"Adam"]
[null,22002,"Rachel",{"$f":"REPLACE(C6,1,0,\",\")","v":",Rachel"},null,null,null,null,22002,"Rachel"]
[null,22003,"Kim",",Kim",null,null,null,null,22003,"Kim"]
[null,22004,"Stuart",",Stuart",null,null,null,null,22004,"Stuart"]
[null,22005,"Jerry",",Jerry",null,null,null,null,22005,"Jerry"]
[null,22006,"Alice",",Alice",null,null,null,null,22006,"Alice"]
[null,22007,"Helen",",Helen",null,null,null,null,22007,"Helen"]
[null,22008,"Fred",",Fred",null,null,null,null,22008,"Fred"]

{"sheet":"Use of SUBSTITUTE Function","index":5,"n_rows":12,"n_cols":8,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,6,1,7]]}
[]
[null," Use of SUBSTITUTE Function",null,null,null,null,"Do it Yourself"]
[]
[null,"Student ID-Name","Student ID,Name",null,null,null,"Student ID-Name","Student ID,Name"]
[null,"22001-Adam",{"$f":"SUBSTITUTE(B5,\"-\",\",\")","v":"22001,Adam"},null,null,null,"22001-Adam"]
[null,"22002-Rachel",{"$f":"SUBSTITUTE(B6,\"-\",\",\")","v":"22002,Rachel"},null,null,null,"22002-Rachel"]
[null,"22003-Kim","22003,Kim",null,null,null,"22003-Kim"]
[null,"22004-Stuart","22004,Stuart",null,null,null,"22004-Stuart"]
[null,"22005-Jerry","22005,Jerry",null,null,null,"22005-Jerry"]
[null,"22006-Alice","22006,Alice",null,null,null,"22006-Alice"]
[null,"22007-Helen","22007,Helen",null,null,null,"22007-Helen"]
[null,"22008-Fred","22008,Fred",null,null,null,"22008-Fred"]

{"sheet":"Employing VBA","index":6,"n_rows":12,"n_cols":11,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,8,1,10]]}
[]
[null,"Employing VBA",null,null,null,null,null,null,"Do it Yourself"]
[]
[null,"Student ID"," Name"," Name with Comma",null,null,null,null,"Student ID"," Name"," Name with Comma"]
[null,22001,"Adam",",Adam",null,null,null,null,22001,"Adam"]
[null,22002,"Rachel",",Rachel",null,null,null,null,22002,"Rachel"]
[null,22003,"Kim",",Kim",null,null,null,null,22003,"Kim"]
[null,22004,"Stuart",",Stuart",null,null,null,null,22004,"Stuart"]
[null,22005,"Jerry",",Jerry",null,null,null,null,22005,"Jerry"]
[null,22006,"Alice",",Alice",null,null,null,null,22006,"Alice"]
[null,22007,"Helen",",Helen",null,null,null,null,22007,"Helen"]
[null,22008,"Fred",",Fred",null,null,null,null,22008,"Fred"]

{"sheet":"Comma Before 1st Text Character","index":7,"n_rows":9,"n_cols":11,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,8,1,10]]}
[]
[null,"Adding Comma Before First Text Character",null,null,null,null,null,null,"Do it Yourself"]
[]
[null,"Product Name","Product Code","Comma before Text",null,null,null,null,"Product Name","Product Code","Comma before Text"]
[null,"Mobile","0234XyABq",{"$f":"REPLACE(C5,MATCH(TRUE,ISERROR(VALUE(MID(C5,ROW(INDIRECT(\"1:\"&LEN(C5))),1))),0),0,\",\")","v":"0234,XyABq"},null,null,null,null,"Mobile","0234XyABq"]
[null,"Headphone","245EqfDX",{"$f":"REPLACE(C6,MATCH(TRUE,ISERROR(VALUE(MID(C6,ROW(INDIRECT(\"1:\"&LEN(C6))),1))),0),0,\",\")","v":"245,EqfDX"},null,null,null,null,"Headphone","245EqfDX"]
[null,"Mouse","25GhQEfr",{"$f":"REPLACE(C7,MATCH(TRUE,ISERROR(VALUE(MID(C7,ROW(INDIRECT(\"1:\"&LEN(C7))),1))),0),0,\",\")","v":"25,GhQEfr"},null,null,null,null,"Mouse","25GhQEfr"]
[null,"Router","2087HfDRwqt",{"$f":"REPLACE(C8,MATCH(TRUE,ISERROR(VALUE(MID(C8,ROW(INDIRECT(\"1:\"&LEN(C8))),1))),0),0,\",\")","v":"2087,HfDRwqt"},null,null,null,null,"Router","2087HfDRwqt"]
[null,"Keyboard","458ABqXzH",{"$f":"REPLACE(C9,MATCH(TRUE,ISERROR(VALUE(MID(C9,ROW(INDIRECT(\"1:\"&LEN(C9))),1))),0),0,\",\")","v":"458,ABqXzH"},null,null,null,null,"Keyboard","458ABqXzH"]