{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Sample Datasheet","SUBSTITUTE Function","User Defined Function","VBA 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":"Sample Datasheet","index":0,"n_rows":12,"n_cols":3,"rows_kept":12,"cut":false,"hidden":false,"merged":[[2,1,2,2]]}
[]
[]
[null,"Removing Non Alphanumeric Characters"]
[]
[null,"Non Alphanumeric Data","Clean Data"]
[null,"T#ul#ip*"]
[null,"#R#ose* "]
[null,"D*ai*s#y"]
[null,"C#a*mel#ia*"]
[null,"S*unfl*ow*er#"]
[null,"*Da*ndel#ion#"]
[null,"Da#*ffo*di#l"]

{"sheet":"SUBSTITUTE Function","index":1,"n_rows":12,"n_cols":3,"rows_kept":12,"cut":false,"hidden":false,"merged":[[2,1,2,2]]}
[]
[]
[null,"Removing Non Alphanumeric Characters"]
[]
[null,"Non Alphanumeric Data","Clean Data"]
[null,"T#ul#ip*",{"$f":"SUBSTITUTE(SUBSTITUTE(B6,\"*\",\"\"),\"#\",\"\")","v":"Tulip"}]
[null,"#R#ose* ",{"$f":"SUBSTITUTE(SUBSTITUTE(B7,\"*\",\"\"),\"#\",\"\")","v":"Rose "}]
[null,"D*ai*s#y","Daisy"]
[null,"C#a*mel#ia*","Camelia"]
[null,"S*unfl*ow*er#","Sunflower"]
[null,"*Da*ndel#ion#","Dandelion"]
[null,"Da#*ffo*di#l","Daffodil"]

{"sheet":"User Defined Function","index":2,"n_rows":12,"n_cols":3,"rows_kept":12,"cut":false,"hidden":false,"merged":[[2,1,2,2]]}
[]
[]
[null,"Removing Non Alphanumeric Characters"]
[]
[null,"Non Alphanumeric Data","Clean Data"]
[null,"%T#u$l#ip(*^%!-)@+",{"$f":"RemoveNonAlphaNumericCharacters(B6)","v":"Tulip"}]
[null,"#R#ose* +_)&%$#@!*(&",{"$f":"RemoveNonAlphaNumericCharacters(B7)","v":"Rose "}]
[null,"!@#%^&$_D*ai*s#y,/\\'][",{"$f":"RemoveNonAlphaNumericCharacters(B8)","v":"Daisy"}]
[null,":<>?C#a*mel#ia*}{\"|\\!%^*",{"$f":"RemoveNonAlphaNumericCharacters(B9)","v":"Camelia"}]
[null,"S*unfl*ow*er#?/<>|}:_)&%",{"$f":"RemoveNonAlphaNumericCharacters(B10)","v":"Sunflower"}]
[null,"<>?{\"]*Da*ndel#ion#",{"$f":"RemoveNonAlphaNumericCharacters(B11)","v":"Dandelion"}]
[null,"~Da#*f*!~fo*di#l(@%$",{"$f":"RemoveNonAlphaNumericCharacters(B12)","v":"Daffodil"}]

{"sheet":"VBA Code","index":3,"n_rows":12,"n_cols":3,"rows_kept":12,"cut":false,"hidden":false,"merged":[[2,1,2,2]]}
[]
[]
[null,"Removing Non Alphanumeric Characters"]
[]
[null,"Non Alphanumeric Data","Clean Data"]
[null,"%T#u$l#ip(*^%!-)@+","Tulip"]
[null,"#R#ose* +_)&%$#@!*(&","Rose"]
[null,"!@#%^&$_D*ai*s#y,/\\'][","Daisy"]
[null,":<>?C#a*mel#ia*}{\"|\\!%^*","Camelia"]
[null,"S*unfl*ow*er#?/<>|}:_)&%","Sunflower"]
[null,"<>?{\"]*Da*ndel#ion#","Dandelion"]
[null,"~Da#*f*!~fo*di#l(@%$","Daffodil"]