{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Find and Replace","Substitute","Nested Substitute","Flash Fill","Code and Substitute","Lambda","Clean","VBA"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":5,"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":"Find and Replace","index":0,"n_rows":9,"n_cols":3,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Remove Symbol in Excel"]
[]
[null,"With Symbol","Without Symbol"]
[null,"#e14","e14"]
[null,"45#as","45as"]
[null,"8#0013",80013]
[null,"65#89",6589]
[null,"789#/o#y","789/oy"]

{"sheet":"Substitute","index":1,"n_rows":9,"n_cols":3,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Remove Symbol in Excel"]
[]
[null,"With Symbol","Without Symbol"]
[null,"#e14",{"$f":"SUBSTITUTE(B5,\"#\",\"\")","v":"e14"}]
[null,"45#as",{"$f":"SUBSTITUTE(B6,\"#\",\"\")","v":"45as"}]
[null,"8#0013","80013"]
[null,"65#89","6589"]
[null,"789#/o#y","789/oy"]

{"sheet":"Nested Substitute","index":2,"n_rows":9,"n_cols":3,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Remove Symbol in Excel"]
[]
[null,"With Symbol","Without Symbol"]
[null,"#e1€4",{"$f":"SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(B5,\"#\",\"\"),\"/\",\"\"),\"€\",\"\")","v":"e14"}]
[null,"45#a/s",{"$f":"SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(B6,\"#\",\"\"),\"/\",\"\"),\"€\",\"\")","v":"45as"}]
[null,"8#00/1€3","80013"]
[null,"65#8€9","6589"]
[null,"789#/o#y","789oy"]

{"sheet":"Flash Fill","index":3,"n_rows":9,"n_cols":3,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Remove Symbol in Excel"]
[]
[null,"With Symbol","Without Symbol"]
[null,"j%y&c","jyc"]
[null,"4%y&w","4yw"]
[null,"5%7&8",578]
[null,"a%o&9","ao9"]
[null,"p%t&k","ptk"]

{"sheet":"Code and Substitute","index":4,"n_rows":9,"n_cols":3,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Remove Symbol in Excel"]
[]
[null,"With Symbol","Without Symbol"]
[null,"©ascii",{"$f":"SUBSTITUTE(B5,CHAR(CODE(B5)),\"\")","v":"ascii"}]
[null,"©utffw",{"$f":"SUBSTITUTE(B6,CHAR(CODE(B6)),\"\")","v":"utffw"}]
[null,"©i90g","i90g"]
[null,"©ghctr","ghctr"]
[null,"©sikp","sikp"]

{"sheet":"Lambda","index":5,"n_rows":9,"n_cols":5,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Remove Symbol in Excel"]
[]
[null,"With Symbol","Without Symbol",null,"Removable Symbols"]
[null,"#e1€4",{"$f":"RemSym(B5,$E$5)","v":"e14"},null,"#/?€|\\><"]
[null,"45#a/s",{"$f":"RemSym(B6,$E$5)","v":"45as"}]
[null,"8#00/1>3",{"$f":"RemSym(B7,$E$5)","v":"80013"}]
[null,"65|8€9",{"$f":"RemSym(B8,$E$5)","v":"6589"}]
[null,"789#/o#y",{"$f":"RemSym(B9,$E$5)","v":"789oy"}]

{"sheet":"Clean","index":6,"n_rows":9,"n_cols":3,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Remove Symbol in Excel"]
[]
[null,"With Symbol","Without Symbol"]
[null,"eg\bse",{"$f":"CLEAN(B5)","v":"egse"}]
[null,"\basd",{"$f":"CLEAN(B6)","v":"asd"}]
[null,{"$f":"\"orui\"&CHAR(8)","v":"orui\b"},"orui"]
[null,"po\bke","poke"]
[null,"562\b  a","562  a"]

{"sheet":"VBA","index":7,"n_rows":9,"n_cols":3,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Remove Symbol in Excel"]
[]
[null,"With Symbol","Without Symbol"]
[null,"#e1|4",{"$f":"RemoveSymbols(B5)","v":"e14"}]
[null,"45#a/s",{"$f":"RemoveSymbols(B6)","v":"45as"}]
[null,"8#00/1>3",{"$f":"RemoveSymbols(B7)","v":"80013"}]
[null,"65|8€9",{"$f":"RemoveSymbols(B8)","v":"6589"}]
[null,"789#/o#y",{"$f":"RemoveSymbols(B9)","v":"789oy"}]