{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Dataset","Ribbon","FIND & REPLACE","SUBSTITUTE","VBA"],"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":8,"n_cols":3,"rows_kept":8,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Find and Replace '*' Character "]
[]
[null,"Employee Details","Replace '*' Character"]
[null,"Jhon*Barker*25*IT","Jhon,Barker,25,IT"]
[null,"Alex*Jane*23*Sales","Alex,Jane,23,Sales"]
[null,"Robert*Chao*29*Marketing","Robert,Chao,29,Marketing"]
[null,"Sally*Brooke*28*HR","Sally,Brooke,28,HR"]

{"sheet":"Ribbon","index":1,"n_rows":8,"n_cols":5,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Use of Ribbon",null,null,"For Practice"]
[]
[null,"Employee Details",null,null,"Employee Details with"]
[null,"Jhon,Barker,25,IT",null,null,"Jhon,Barker,25,IT"]
[null,"Alex,Jane,23,Sales",null,null,"Alex,Jane,23,Sales"]
[null,"Robert,Chao,29,Marketing",null,null,"Robert,Chao,29,Marketing"]
[null,"Sally,Brooke,28,HR",null,null,"Sally,Brooke,28,HR"]

{"sheet":"FIND & REPLACE","index":2,"n_rows":8,"n_cols":7,"rows_kept":8,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,5,1,6]]}
[]
[null,"Use of FIND & REPLACE Functions",null,null,null,"For Practice"]
[]
[null,"Name","Short Name",null,null,"Name","Short Name"]
[null,"Jhon*Barker",{"$f":"REPLACE(B5,1,FIND(\"*\",B5),LEFT(B5)&\".\")","v":"J.Barker"},null,null,"Jhon*Barker"]
[null,"Alex*Jane",{"$f":"REPLACE(B6,1,FIND(\"*\",B6),LEFT(B6)&\".\")","v":"A.Jane"},null,null,"Alex*Jane"]
[null,"Robert*Chao","R.Chao",null,null,"Robert*Chao"]
[null,"Sally*Brooke","S.Brooke",null,null,"Sally*Brooke"]

{"sheet":"SUBSTITUTE","index":3,"n_rows":8,"n_cols":7,"rows_kept":8,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,5,1,6]]}
[]
[null,"Use of SUBSTITUTE Function",null,null,null,"For Practice"]
[]
[null,"Employee Details with '*' Character","Replace '*' to ','",null,null,"Employee Details with '*' Character","Replace '*' to ','"]
[null,"Jhon*Barker*25*IT",{"$f":"SUBSTITUTE(B5,\"*\",\",\")","v":"Jhon,Barker,25,IT"},null,null,"Jhon*Barker*25*IT"]
[null,"Alex*Jane*23*Sales",{"$f":"SUBSTITUTE(B6,\"*\",\",\")","v":"Alex,Jane,23,Sales"},null,null,"Alex*Jane*23*Sales"]
[null,"Robert*Chao*29*Marketing","Robert,Chao,29,Marketing",null,null,"Robert*Chao*29*Marketing"]
[null,"Sally*Brooke*28*HR","Sally,Brooke,28,HR",null,null,"Sally*Brooke*28*HR"]

{"sheet":"VBA","index":4,"n_rows":2,"n_cols":2,"rows_kept":2,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Use of VBA"]