{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Using Power Query","Table2","Applying VBA Code","Using User-Defined Function","Replacing Special Characters "],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":1,"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":"Using Power Query","index":0,"n_rows":10,"n_cols":9,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,7,1,8]]}
[]
[null,"Using Power Query",null,null,null,null,null,"Do It Yourself"]
[]
[null,"Global Trade Item Number","Special Characters",null,null,null,null,"Global Trade Item Number","Special Characters"]
[null,"123,$90&975%",",$&%",null,null,null,null,"3,$90&975"]
[null,"24&*8742","*",null,null,null,null,"4&8742"]
[null,"23*90#","*#",null,null,null,null,"3*0290#"]
[null,"234765$32,",",",null,null,null,null,"23,47.65$32,"]
[null,"3456*","*",null,null,null,null,"56*78,"]
[null,"345354,4",",",null,null,null,null,"34,53.54,4"]

{"sheet":"Table2","index":1,"n_rows":9,"n_cols":2,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
["ExternalData_1"]
[]
["Global Trade Item Number","Special Characters"]
["123,$90&975%",",$&%"]
["24&*8742","*"]
["23*90#","*#"]
["234765$32,",","]
["3456*","*"]
["345354,4",","]

{"sheet":"Applying VBA Code","index":2,"n_rows":10,"n_cols":9,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,7,1,8]]}
[]
[null,"Applying VBA Code",null,null,null,null,null,"Do It Yourself"]
[]
[null,"Global Trade Item Number","Special Characters Check",null,null,null,null,"Global Trade Item Number","Special Characters"]
[null,"123,$90&975%",{"$f":"FindSpecialCharacters(B5)","v":true},null,null,null,null,"3,$90&975"]
[null,"24&*8742",{"$f":"FindSpecialCharacters(B6)","v":true},null,null,null,null,"4&8742"]
[null,"23*90#",{"$f":"FindSpecialCharacters(B7)","v":true},null,null,null,null,"3*0290#"]
[null,"234765$32,",{"$f":"FindSpecialCharacters(B8)","v":true},null,null,null,null,"23,47.65$32,"]
[null,"3456*",{"$f":"FindSpecialCharacters(B9)","v":true},null,null,null,null,"56*78,"]
[null,3453544,{"$f":"FindSpecialCharacters(B10)","v":false},null,null,null,null,"34,53.54,4"]

{"sheet":"Using User-Defined Function","index":3,"n_rows":10,"n_cols":9,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,7,1,8]]}
[]
[null,"Using User-Defined Function",null,null,null,null,null,"Do It Yourself"]
[]
[null,"Global Trade Item Number","Special Characters Check",null,null,null,null,"Global Trade Item Number","Special Characters"]
[null,"123,$90&975%",{"$f":"Check_Special_Characters(B5)","v":true},null,null,null,null,"3,$90&975"]
[null,"24&*8742",{"$f":"Check_Special_Characters(B6)","v":true},null,null,null,null,"4&8742"]
[null,"23*90#",{"$f":"Check_Special_Characters(B7)","v":true},null,null,null,null,"3*0290#"]
[null,"234765$32,",{"$f":"Check_Special_Characters(B8)","v":true},null,null,null,null,"23,47.65$32,"]
[null,"3456*",{"$f":"Check_Special_Characters(B9)","v":true},null,null,null,null,"56*78,"]
[null,3453544,{"$f":"Check_Special_Characters(B10)","v":false},null,null,null,null,"34,53.54,4"]

{"sheet":"Replacing Special Characters ","index":4,"n_rows":10,"n_cols":9,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,7,1,8]]}
[]
[null,"Replacing Special Characters ",null,null,null,null,null,"Do It Yourself"]
[]
[null,"Global Trade Item Number","Replace Special Characters",null,null,null,null,"Global Trade Item Number","Special Characters"]
[null,"123,$90&975%",12390975,null,null,null,null,"3,$90&975"]
[null,"24&*8742",248742,null,null,null,null,"4&8742"]
[null,"23*90#",2390,null,null,null,null,"3*0290#"]
[null,"234765$32,",23476532,null,null,null,null,"23,47.65$32,"]
[null,"3456*",3456,null,null,null,null,"56*78,"]
[null,"345354,4",3453544,null,null,null,null,"34,53.54,4"]