{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Strip Characters - Examples","Remove specific char","Remove multiple chars","LAMBDA","UDF","Non-printable chars"],"not_rendered":{"charts":0,"images":4,"macros":1,"external_links":0,"defined_names":9,"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":"Strip Characters - Examples","index":0,"n_rows":19,"n_cols":7,"rows_kept":19,"cut":false,"hidden":false,"merged":[[14,1,14,2],[3,1,3,2],[5,1,5,2],[11,1,11,2],[12,1,12,2],[13,1,13,2]]}
[]
[]
[]
[null,"Remove Unwanted Characters in Excel"]
[]
[null,"The workbook shows how to delete specific characters from a text string and remove unwanted characters from multiple cells at once."]
[null,"Author","Ablebits.com"]
[null,"Last update","2021-08-02"]
[null,"Tutorial URL","Remove unwanted characters from string in Excel "]
[]
[null,"Examples:"]
["• ","Remove a specific character"]
["• ","Delete multiple characters"]
["• ","LAMBDA to remove all unwanted characters at once"]
["• ","User-defined functions to remove special characters"]
["• ","Strip non-printable characters "]
[]
[]
[null,null,null,null,null,null," "]

{"sheet":"Remove specific char","index":1,"n_rows":6,"n_cols":2,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
["Original data","Result"]
["100¿",{"$f":"SUBSTITUTE(A2, CHAR(191), \"\")","v":"100"}]
["¿101",{"$f":"SUBSTITUTE(A3, CHAR(191), \"\")","v":"101"}]
["1¿02","102"]
["¿103¿","103"]
["¿1¿04¿","104"]

{"sheet":"Remove multiple chars","index":2,"n_rows":6,"n_cols":2,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
["Original data","Result"]
["?100¿",{"$f":"SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A2, \"!\", \"\"), CHAR(161), \"\"), \"?\", \"\"), CHAR(191), \"\")","v":"100"}]
["¿101!",{"$f":"SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A3, \"!\", \"\"), CHAR(161), \"\"), \"?\", \"\"), CHAR(191), \"\")","v":"101"}]
["1!02¡","102"]
["¿103¡","103"]
["!1¿04¡","104"]

{"sheet":"LAMBDA","index":3,"n_rows":11,"n_cols":10,"rows_kept":11,"cut":false,"hidden":false,"merged":[[0,6,0,8],[0,0,0,3]]}
["Remove specified characters",null,null,null,null,null,"Remove predefined characters"]
["Original data","Result",null,"Chars to remove",null,null,"Original data","Remove Special Chars","Remove Numbers"]
["?100¿",{"$f":"RemoveChars(A3:A7, D3)","v":"100"},null,"?¿!¡*%",null,null,"?A100¿",{"$f":"RemoveSpecialChars(G3)","v":"A100"},{"$f":"RemoveNumbers(G3)","v":"?A¿"}]
["¿101!","101",null,null,null,null,"B¿101!",{"$f":"RemoveSpecialChars(G4)","v":"B101"},{"$f":"RemoveNumbers(G4)","v":"B¿!"}]
["1!02%*","102",null,null,null,null,"C1!02%*",{"$f":"RemoveSpecialChars(G5)","v":"C102"},{"$f":"RemoveNumbers(G5)","v":"C!%*"}]
["¿103¡*","103",null,null,null,null,"D¿103¡*",{"$f":"RemoveSpecialChars(G6)","v":"D103"},{"$f":"RemoveNumbers(G6)","v":"D¿¡*"}]
["!1%04¡","104",null,null,null,null,"E!1%04¡",{"$f":"RemoveSpecialChars(G7)","v":"E104"},{"$f":"RemoveNumbers(G7)","v":"E!%¡"}]
[]
[]
[]
[null,null,null,null,null,null,null,null,null," "]

{"sheet":"UDF","index":4,"n_rows":7,"n_cols":8,"rows_kept":7,"cut":false,"hidden":false,"merged":[[0,0,0,3],[0,6,0,7]]}
["Remove specified characters",null,null,null,null,null,"Remove predefined characters"]
["Original data","Result",null,"Chars to remove",null,null,"Original data","Result"]
["?100¿",{"$f":"RemoveUnwantedChars(A3, $D$3)","v":"100"},null,"?¿!¡*%",null,null,"?100¿",{"$f":"RemoveSpecialChars(G3)","v":"100"}]
["¿101!",{"$f":"RemoveUnwantedChars(A4, $D$3)","v":"101"},null,null,null,null,"¿101!",{"$f":"RemoveSpecialChars(G4)","v":"101"}]
["1!02%*",{"$f":"RemoveUnwantedChars(A5, $D$3)","v":"102"},null,null,null,null,"1!02%*",{"$f":"RemoveSpecialChars(G5)","v":"102"}]
["¿103¡*",{"$f":"RemoveUnwantedChars(A6, $D$3)","v":"103"},null,null,null,null,"¿103¡*",{"$f":"RemoveSpecialChars(G6)","v":"103"}]
["!1%04¡",{"$f":"RemoveUnwantedChars(A7, $D$3)","v":"104"},null,null,null,null,"!1%04¡",{"$f":"RemoveSpecialChars(G7)","v":"104"}]

{"sheet":"Non-printable chars","index":5,"n_rows":5,"n_cols":3,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
["Original data","Remove Non-Printable Chars & Extra Spaces","Remove Non-Printable Chars & All Spaces"]
["  AA-100\u0001",{"$f":"TRIM(CLEAN(A2))","v":"AA-100"},{"$f":"TRIM(CLEAN((SUBSTITUTE(A2,CHAR(32),\"\"))))","v":"AA-100"}]
["   \u0001BB/   101",{"$f":"TRIM(CLEAN(A3))","v":"BB/ 101"},{"$f":"TRIM(CLEAN((SUBSTITUTE(A3,CHAR(32),\"\"))))","v":"BB/101"}]
["\fC/\u0001102/C","C/102/C","C/102/C"]
["D*1D  0\u0001*3","D*1D 0*3","D*1D0*3"]