{"text_format":"1","workbook":"xlsx","n_sheets":10,"sheets":["Overview","Dataset","SUBSTITUTE","RIGHT, and LEN","LEFT, and LEN","Flash Fill","Find and Replace","Power Query","Table1 (2)","VBA"],"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":"Overview","index":0,"n_rows":11,"n_cols":6,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Overview of Removing Special Characters"]
[]
[null,"ID","Name",null,"Method","Output"]
[null,3441,"#Sen!#$$",null,"SUBSTITUTE Function\n=SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(C5,\"#\",\"\"),\"!\",\"\"),\"$\",\"\"),\"%\",\"\"),\"&\",\"\")","Removed Special Characters"]
[null,8564,"#Faraday%&",null,"RIGHT, LEN Functions\n=RIGHT(C5,LEN(C5)-1)","Removed Special Characters"]
[null,9641,"!Dilly$&",null,"LEFT, LEN Functions\n=LEFT(C5,LEN(C5)-2)","Removed Special Characters"]
[null,2381,"$Rachel$!",null,"Flash Fill Feature","Removed Special Characters"]
[null,9665,"#Kevin!#$",null,"Find and Replace Command","Removed Special Characters"]
[null,7432,"!Jim&$",null,"Power Query Tool","Removed Special Characters"]
[null,8513,"&Cooper!#",null,"VBA code","Removed Special Characters"]

{"sheet":"Dataset","index":1,"n_rows":11,"n_cols":3,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Removing Special Characters"]
[]
[null,"ID","Name"]
[null,3441,"#Sen!#$$"]
[null,8564,"#Faraday%&"]
[null,9641,"!Dilly$&"]
[null,2381,"$Rachel$!"]
[null,9665,"#Kevin!#$"]
[null,7432,"!Jim&$"]
[null,8513,"&Cooper!#"]

{"sheet":"SUBSTITUTE","index":2,"n_rows":11,"n_cols":5,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Using SUBSTITUTE Function"]
[]
[null,"ID","Name",null,"Output"]
[null,3441,"#Sen!#$$",null,{"$f":"SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(C5,\"#\",\"\"),\"!\",\"\"),\"$\",\"\"),\"%\",\"\"),\"&\",\"\")","v":"Sen"}]
[null,8564,"#Faraday%&",null,{"$f":"SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(C6,\"#\",\"\"),\"!\",\"\"),\"$\",\"\"),\"%\",\"\"),\"&\",\"\")","v":"Faraday"}]
[null,9641,"!Dilly$&",null,"Dilly"]
[null,2381,"$Rachel$!",null,"Rachel"]
[null,9665,"#Kevin!#$",null,"Kevin"]
[null,7432,"!Jim&$",null,"Jim"]
[null,8513,"&Cooper!#",null,"Cooper"]

{"sheet":"RIGHT, and LEN","index":3,"n_rows":11,"n_cols":5,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Using RIGHT, LEN Functions"]
[]
[null,"ID","Name",null,"Output"]
[null,3441,"#Sen!#$$",null,{"$f":"RIGHT(C5,LEN(C5)-1)","v":"Sen!#$$"}]
[null,8564,"#Faraday%&",null,{"$f":"RIGHT(C6,LEN(C6)-1)","v":"Faraday%&"}]
[null,9641,"!Dilly$&",null,"Dilly$&"]
[null,2381,"$Rachel$!",null,"Rachel$!"]
[null,9665,"#Kevin#$",null,"Kevin#$"]
[null,7432,"!Jim&$",null,"Jim&$"]
[null,8513,"&Cooper!#",null,"Cooper!#"]

{"sheet":"LEFT, and LEN","index":4,"n_rows":11,"n_cols":5,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Using LEFT, LEN Functions"]
[]
[null,"ID","Name",null,"Output"]
[null,3441,"#Sen$&",null,{"$f":"LEFT(C5,LEN(C5)-2)","v":"#Sen"}]
[null,8564,"#Faraday%&",null,{"$f":"LEFT(C6,LEN(C6)-2)","v":"#Faraday"}]
[null,9641,"!Dilly!$",null,"!Dilly"]
[null,2381,"$Rachel$!",null,"$Rachel"]
[null,9665,"#Kevin#$",null,"#Kevin"]
[null,7432,"!Jim&$",null,"!Jim"]
[null,8513,"&Cooper!#",null,"&Cooper"]

{"sheet":"Flash Fill","index":5,"n_rows":11,"n_cols":4,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Using Flash Fill Feature"]
[]
[null,"ID","Name","Output"]
[null,3441,"#Sen$&","Sen"]
[null,8564,"#Faraday%&","Faraday"]
[null,9641,"!Dilly$#","Dilly"]
[null,2381,"$Rachel$!","Rachel"]
[null,9665,"#Kevin$#","Kevin"]
[null,7432,"!Jim$&","Jim"]
[null,8513,"!Cooper$%","Cooper"]

{"sheet":"Find and Replace","index":6,"n_rows":11,"n_cols":4,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Using Find and Replace Feature"]
[]
[null,"ID","Name","Output"]
[null,3441,"Sen$&%","Sen"]
[null,8564,"Faraday$&%","Faraday"]
[null,9641,"Dilly$&%","Dilly"]
[null,2381,"Rachel$&%","Rachel"]
[null,9665,"Kevin$&%","Kevin"]
[null,7432,"Jim$&%","Jim"]
[null,8513,"Cooper$&%","Cooper"]

{"sheet":"Power Query","index":7,"n_rows":11,"n_cols":4,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Using Power Query Tool"]
[]
[null,"ID","Name","Output"]
[null,3441,"#Sen$&","Sen"]
[null,8564,"#Faraday%&","Faraday"]
[null,9641,"!Dilly$#","Dilly"]
[null,2381,"$Rachel$!","Rachel"]
[null,9665,"#Kevin#$","Kevin"]
[null,7432,"!Jim&$","Jim"]
[null,8513,"&Cooper!#","Cooper"]

{"sheet":"Table1 (2)","index":8,"n_rows":8,"n_cols":2,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
["Name","Output"]
["#Sen$&","Sen"]
["#Faraday%&","Faraday"]
["!Dilly$#","Dilly"]
["$Rachel$!","Rachel"]
["#Kevin#$","Kevin"]
["!Jim&$","Jim"]
["&Cooper!#","Cooper"]

{"sheet":"VBA","index":9,"n_rows":11,"n_cols":4,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Using VBA Code"]
[]
[null,"ID","Name","Output"]
[null,3441,"Sen$&%",{"$f":"Erase_Special_Characters(C5)","v":"Sen"}]
[null,8564,"Faraday$&%",{"$f":"Erase_Special_Characters(C6)","v":"Faraday"}]
[null,9641,"Dilly$&%",{"$f":"Erase_Special_Characters(C7)","v":"Dilly"}]
[null,2381,"Rachel$&%",{"$f":"Erase_Special_Characters(C8)","v":"Rachel"}]
[null,9665,"Kevin$&%",{"$f":"Erase_Special_Characters(C9)","v":"Kevin"}]
[null,7432,"Jim$&%",{"$f":"Erase_Special_Characters(C10)","v":"Jim"}]
[null,8513,"Cooper$&%",{"$f":"Erase_Special_Characters(C11)","v":"Cooper"}]