{"text_format":"1","workbook":"xlsx","n_sheets":14,"sheets":["Home Page","List of All 255 Chars in Excel","1.1 Replace with Same Char","1.2 Different Char Each Time","2. Chars with Pattern","3.1 SUBSTITUTE","3.2 Nested SUBSTITUTE","3.3 REPLACE","4. Special Char with Criteria","5. LAMBDA","6. VBA","Nonwritable Chars","Foreign Characters","Non-Printable Chars"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":3,"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":"Home Page","index":0,"n_rows":34,"n_cols":3,"rows_kept":34,"cut":false,"hidden":false,"merged":[[15,1,15,2],[20,1,20,3],[22,1,22,4],[26,1,26,4]]}
[]
[]
[]
[]
[]
[]
[null,"How to Replace Special Characters in Excel"]
[]
[null,"Learn to Replace a Special Character with another or an empty string. Read the article we provided and practice these in practice section."]
[]
[null,"Prepared By","Abrar-ur-Rahman Niloy"]
[null,"Last Update","2023-07-11"]
[null,"Reviewed By","Masum Mahdy"]
[null,"Article Link","How to Replace Special Characters in Excel"]
[]
[null,"Main Content"]
[null,"List of All 255 Characters in Excel"]
[null,"1. Replace Special Characters Using Find and Replace Feature"]
[null,"Replace All Occurences of a Character"]
[null,"Replace the Same Character with Different Ones in Different Instances"]
[null,"2. Replacing Characters with Patterns"]
[null,"Using Flash Fill"]
[null,"3. Replacing Special Characters with Functions"]
[null,"Using the SUBSTITUTE Function"]
[null,"Using Nested SUBSTITUTE Function"]
[null,"Using the REPLACE Function"]
[null,"4. Replace Any Special Character with Formula"]
[null,"Replace Characters that Are Not Numbers"]
[null,"5. Replacing Special Characters with UDF"]
[null,"Using LAMBDA Function"]
[null,"Using VBA"]
[]
[null,"Replace Foreign Characters with UDF"]
[null,"Remove Non-Printable Characters"]

{"sheet":"List of All 255 Chars in Excel","index":1,"n_rows":256,"n_cols":11,"rows_kept":256,"cut":false,"hidden":false,"merged":[]}
["All Characters","Code",null,"Non Printable Characters","Code",null,"Printable Characters","Code",null,"Special Characters","Code"]
["\u0001",1,null,"\u0001",1,null," ",32,null,"€",128]
["\u0002",2,null,"\u0002",2,null,"!",33,null,"\u0081",129]
["\u0003",3,null,"\u0003",3,null,"\"",34,null,"‚",130]
["\u0004",4,null,"\u0004",4,null,"#",35,null,"ƒ",131]
["\u0005",5,null,"\u0005",5,null,"$",36,null,"„",132]
["\u0006",6,null,"\u0006",6,null,"%",37,null,"…",133]
["\u0007",7,null,"\u0007",7,null,"&",38,null,"†",134]
["\b",8,null,"\b",8,null,"'",39,null,"‡",135]
["\t",9,null,"\t",9,null,"(",40,null,"ˆ",136]
["\n",10,null,"\n",10,null,")",41,null,"‰",137]
["\u000b",11,null,"\u000b",11,null,"*",42,null,"Š",138]
["\f",12,null,"\f",12,null,"+",43,null,"‹",139]
["\r",13,null,"\r",13,null,",",44,null,"Œ",140]
["\u000e",14,null,"\u000e",14,null,"-",45,null,"\u008d",141]
["\u000f",15,null,"\u000f",15,null,".",46,null,"Ž",142]
["\u0010",16,null,"\u0010",16,null,"/",47,null,"\u008f",143]
["\u0011",17,null,"\u0011",17,null,"0",48,null,"\u0090",144]
["\u0012",18,null,"\u0012",18,null,"1",49,null,"‘",145]
["\u0013",19,null,"\u0013",19,null,"2",50,null,"’",146]
["\u0014",20,null,"\u0014",20,null,"3",51,null,"“",147]
["\u0015",21,null,"\u0015",21,null,"4",52,null,"”",148]
["\u0016",22,null,"\u0016",22,null,"5",53,null,"•",149]
["\u0017",23,null,"\u0017",23,null,"6",54,null,"–",150]
["\u0018",24,null,"\u0018",24,null,"7",55,null,"—",151]
["\u0019",25,null,"\u0019",25,null,"8",56,null,"˜",152]
["\u001a",26,null,"\u001a",26,null,"9",57,null,"™",153]
["\u001b",27,null,"\u001b",27,null,":",58,null,"š",154]
["\u001c",28,null,"\u001c",28,null,";",59,null,"›",155]
["\u001d",29,null,"\u001d",29,null,"<",60,null,"œ",156]
["\u001e",30,null,"\u001e",30,null,"=",61,null,"\u009d",157]
["\u001f",31,null,"\u001f",31,null,">",62,null,"ž",158]
[" ",32,null,null,null,null,"?",63,null,"Ÿ",159]
["!",33,null,null,null,null,"@",64,null," ",160]
["\"",34,null,null,null,null,"A",65,null,"¡",161]
["#",35,null,null,null,null,"B",66,null,"¢",162]
["$",36,null,null,null,null,"C",67,null,"£",163]
["%",37,null,null,null,null,"D",68,null,"¤",164]
["&",38,null,null,null,null,"E",69,null,"¥",165]
["'",39,null,null,null,null,"F",70,null,"¦",166]
["(",40,null,null,null,null,"G",71,null,"§",167]
[")",41,null,null,null,null,"H",72,null,"¨",168]
["*",42,null,null,null,null,"I",73,null,"©",169]
["+",43,null,null,null,null,"J",74,null,"ª",170]
[",",44,null,null,null,null,"K",75,null,"«",171]
["-",45,null,null,null,null,"L",76,null,"¬",172]
[".",46,null,null,null,null,"M",77,null,"­",173]
["/",47,null,null,null,null,"N",78,null,"®",174]
["0",48,null,null,null,null,"O",79,null,"¯",175]
["1",49,null,null,null,null,"P",80,null,"°",176]
["2",50,null,null,null,null,"Q",81,null,"±",177]
["3",51,null,null,null,null,"R",82,null,"²",178]
["4",52,null,null,null,null,"S",83,null,"³",179]
["5",53,null,null,null,null,"T",84,null,"´",180]
["6",54,null,null,null,null,"U",85,null,"µ",181]
["7",55,null,null,null,null,"V",86,null,"¶",182]
["8",56,null,null,null,null,"W",87,null,"·",183]
["9",57,null,null,null,null,"X",88,null,"¸",184]
[":",58,null,null,null,null,"Y",89,null,"¹",185]
[";",59,null,null,null,null,"Z",90,null,"º",186]
["<",60,null,null,null,null,"[",91,null,"»",187]
["=",61,null,null,null,null,"\\",92,null,"¼",188]
[">",62,null,null,null,null,"]",93,null,"½",189]
["?",63,null,null,null,null,"^",94,null,"¾",190]
["@",64,null,null,null,null,"_",95,null,"¿",191]
["A",65,null,null,null,null,"`",96,null,"À",192]
["B",66,null,null,null,null,"a",97,null,"Á",193]
["C",67,null,null,null,null,"b",98,null,"Â",194]
["D",68,null,null,null,null,"c",99,null,"Ã",195]
["E",69,null,null,null,null,"d",100,null,"Ä",196]
["F",70,null,null,null,null,"e",101,null,"Å",197]
["G",71,null,null,null,null,"f",102,null,"Æ",198]
["H",72,null,null,null,null,"g",103,null,"Ç",199]
["I",73,null,null,null,null,"h",104,null,"È",200]
["J",74,null,null,null,null,"i",105,null,"É",201]
["K",75,null,null,null,null,"j",106,null,"Ê",202]
["L",76,null,null,null,null,"k",107,null,"Ë",203]
["M",77,null,null,null,null,"l",108,null,"Ì",204]
["N",78,null,null,null,null,"m",109,null,"Í",205]
["O",79,null,null,null,null,"n",110,null,"Î",206]
["P",80,null,null,null,null,"o",111,null,"Ï",207]
["Q",81,null,null,null,null,"p",112,null,"Ð",208]
["R",82,null,null,null,null,"q",113,null,"Ñ",209]
["S",83,null,null,null,null,"r",114,null,"Ò",210]
["T",84,null,null,null,null,"s",115,null,"Ó",211]
["U",85,null,null,null,null,"t",116,null,"Ô",212]
["V",86,null,null,null,null,"u",117,null,"Õ",213]
["W",87,null,null,null,null,"v",118,null,"Ö",214]
["X",88,null,null,null,null,"w",119,null,"×",215]
["Y",89,null,null,null,null,"x",120,null,"Ø",216]
["Z",90,null,null,null,null,"y",121,null,"Ù",217]
["[",91,null,null,null,null,"z",122,null,"Ú",218]
["\\",92,null,null,null,null,"{",123,null,"Û",219]
["]",93,null,null,null,null,"|",124,null,"Ü",220]
["^",94,null,null,null,null,"}",125,null,"Ý",221]
["_",95,null,null,null,null,"~",126,null,"Þ",222]
["`",96,null,null,null,null,"\u007f",127,null,"ß",223]
["a",97,null,null,null,null,null,null,null,"à",224]
["b",98,null,null,null,null,null,null,null,"á",225]
["c",99,null,null,null,null,null,null,null,"â",226]
["d",100,null,null,null,null,null,null,null,"ã",227]
["e",101,null,null,null,null,null,null,null,"ä",228]
["f",102,null,null,null,null,null,null,null,"å",229]
["g",103,null,null,null,null,null,null,null,"æ",230]
["h",104,null,null,null,null,null,null,null,"ç",231]
["i",105,null,null,null,null,null,null,null,"è",232]
["j",106,null,null,null,null,null,null,null,"é",233]
["k",107,null,null,null,null,null,null,null,"ê",234]
["l",108,null,null,null,null,null,null,null,"ë",235]
["m",109,null,null,null,null,null,null,null,"ì",236]
["n",110,null,null,null,null,null,null,null,"í",237]
["o",111,null,null,null,null,null,null,null,"î",238]
["p",112,null,null,null,null,null,null,null,"ï",239]
["q",113,null,null,null,null,null,null,null,"ð",240]
["r",114,null,null,null,null,null,null,null,"ñ",241]
["s",115,null,null,null,null,null,null,null,"ò",242]
["t",116,null,null,null,null,null,null,null,"ó",243]
["u",117,null,null,null,null,null,null,null,"ô",244]
["v",118,null,null,null,null,null,null,null,"õ",245]
["w",119,null,null,null,null,null,null,null,"ö",246]
["x",120,null,null,null,null,null,null,null,"÷",247]
["y",121,null,null,null,null,null,null,null,"ø",248]
["z",122,null,null,null,null,null,null,null,"ù",249]
["{",123,null,null,null,null,null,null,null,"ú",250]
["|",124,null,null,null,null,null,null,null,"û",251]
["}",125,null,null,null,null,null,null,null,"ü",252]
["~",126,null,null,null,null,null,null,null,"ý",253]
["\u007f",127,null,null,null,null,null,null,null,"þ",254]
["€",128,null,null,null,null,null,null,null,"ÿ",255]
["\u0081",129]
["‚",130]
["ƒ",131]
["„",132]
["…",133]
["†",134]
["‡",135]
["ˆ",136]
["‰",137]
["Š",138]
["‹",139]
["Œ",140]
["\u008d",141]
["Ž",142]
["\u008f",143]
["\u0090",144]
["‘",145]
["’",146]
["“",147]
["”",148]
["•",149]
["–",150]
["—",151]
["˜",152]
["™",153]
["š",154]
["›",155]
["œ",156]
["\u009d",157]
["ž",158]
["Ÿ",159]
[" ",160]
["¡",161]
["¢",162]
["£",163]
["¤",164]
["¥",165]
["¦",166]
["§",167]
["¨",168]
["©",169]
["ª",170]
["«",171]
["¬",172]
["­",173]
["®",174]
["¯",175]
["°",176]
["±",177]
["²",178]
["³",179]
["´",180]
["µ",181]
["¶",182]
["·",183]
["¸",184]
["¹",185]
["º",186]
["»",187]
["¼",188]
["½",189]
["¾",190]
["¿",191]
["À",192]
["Á",193]
["Â",194]
["Ã",195]
["Ä",196]
["Å",197]
["Æ",198]
["Ç",199]
["È",200]
["É",201]
["Ê",202]
["Ë",203]
["Ì",204]
["Í",205]
["Î",206]
["Ï",207]
["Ð",208]
["Ñ",209]
["Ò",210]
["Ó",211]
["Ô",212]
["Õ",213]
["Ö",214]
["×",215]
["Ø",216]
["Ù",217]
["Ú",218]
["Û",219]
["Ü",220]
["Ý",221]
["Þ",222]
["ß",223]
["à",224]
["á",225]
["â",226]
["ã",227]
["ä",228]
["å",229]
["æ",230]
["ç",231]
["è",232]
["é",233]
["ê",234]
["ë",235]
["ì",236]
["í",237]
["î",238]
["ï",239]
["ð",240]
["ñ",241]
["ò",242]
["ó",243]
["ô",244]
["õ",245]
["ö",246]
["÷",247]
["ø",248]
["ù",249]
["ú",250]
["û",251]
["ü",252]
["ý",253]
["þ",254]
["ÿ",255]

{"sheet":"1.1 Replace with Same Char","index":2,"n_rows":12,"n_cols":20,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
[null,"Using Find and Replace Feature to Replace Special Characters in Excel"]
[]
[null,"Case 1: Replace All Occurrences of a Character from a Range",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Practice Here"]
[]
[null,"Product","Invalid Product Codes",null,"Corrected Product Codes",null,null,null,null,null,null,null,null,null,null,null,null,null,"Product","Product Codes"]
[null,"Eraser","4227™",null,4227,null,"Notes:",null,null,null,null,null,null,null,null,null,null,null,"Eraser","4227™"]
[null,"Ruler","™4685",null,4685,null,"1. Press CTRL+H to get the Find and Replace feature.",null,null,null,null,null,null,null,null,null,null,null,"Ruler","™4685"]
[null,"Gel Pen","™™3021",null,3021,null,"2. Type the special character (? here) in Find what box.",null,null,null,null,null,null,null,null,null,null,null,"Gel Pen","™™3021"]
[null,"Fountain Pen","319™6",null,3196,null,"3. Type your desired character in the Replace with box (here, empty string \"\")",null,null,null,null,null,null,null,null,null,null,null,"Fountain Pen","319™6"]
[null,"B2 Pencil","435™6",null,4356,null,null,null,null,null,null,null,null,null,null,null,null,null,"B2 Pencil","435™6"]
[null,"B3 Pencil","4931™™™",null,4931,null,null,null,null,null,null,null,null,null,null,null,null,null,"B3 Pencil","4931™™™"]
[null,"Sharpener","3953™",null,3953,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sharpener","3953™"]

{"sheet":"1.2 Different Char Each Time","index":3,"n_rows":12,"n_cols":13,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
[null,"Using Find and Replace Feature to Replace Special Characters in Excel"]
[]
[null,"Case 2: Replace Same Character with Different Characters Each Time",null,null,null,null,null,null,null,null,null,null,"Practice Here"]
[]
[null,"Original Text","Corrected Text After \"›\" Replaced with an Appropriate One",null,"Changes We Made",null,null,null,null,null,null,null,"Original Text"]
[null,"Wow™ Look at it go!","Wow! Look at it go!",null,"Wow™ >> Wow!",null,null,null,null,null,null,null,"Wow™ Look at it go!"]
[null,"It™s a bird.","It's a bird.",null,"It™s >> It's",null,null,null,null,null,null,null,"It™s a bird."]
[null,"These tickets are non™refundable","These tickets are non-refundable",null,"non™refundable >> non-refundable",null,null,null,null,null,null,null,"These tickets are non™refundable"]
[null,"™Ali\" is the greatest fighter.","\"Ali\" is the greatest fighter.",null,"™Ali\" >> \"Ali\"",null,null,null,null,null,null,null,"™Ali\" is the greatest fighter."]
[null,"The value of pi is 3™14.","The value of pi is 3.14.",null,"3™14 >> 3.14",null,null,null,null,null,null,null,"The value of pi is 3™14."]
[]
[null,"Note: Type the desired  character in the Replace with box each time and press Replace and Find Next buttons till you complete all replacing."]

{"sheet":"2. Chars with Pattern","index":4,"n_rows":14,"n_cols":12,"rows_kept":14,"cut":false,"hidden":false,"merged":[[13,1,18,6]]}
[null,"How to Replace Special Characters in Excel with Flash Fill"]
[]
[null,"Replace Special Characters That Have Specific Pattern",null,null,null,null,null,null,null,"Practice Here"]
[]
[null,"Product","Invalid Product Codes","Corrected Product Codes",null,null,null,null,null,"Product","Invalid Product Codes","Corrected Product Codes"]
[null,"Eraser","™4227™",4227,null,null,null,null,null,"Eraser","™4227™"]
[null,"Ruler","™4685™",4685,null,null,null,null,null,"Ruler","™4685™"]
[null,"Gel Pen","™3021™",3021,null,null,null,null,null,"Gel Pen","™3021™"]
[null,"Fountain Pen","™3196™",3196,null,null,null,null,null,"Fountain Pen","™3196™"]
[null,"B2 Pencil","™4356™",4356,null,null,null,null,null,"B2 Pencil","™4356™"]
[null,"B3 Pencil","™4931™",4931,null,null,null,null,null,"B3 Pencil","™4931™"]
[null,"Sharpener","™3953™",3953,null,null,null,null,null,"Sharpener","™3953™"]
[]
[null,"Note: Invalid Product Codes and Corrected Product Codes must be in adjacent columns just like this worksheet. Otherwsie, Flash Fill cannot sense the pattern and cannot return any output."]

{"sheet":"3.1 SUBSTITUTE","index":5,"n_rows":14,"n_cols":18,"rows_kept":14,"cut":false,"hidden":false,"merged":[[13,1,16,9]]}
[null,"How to Replace Special Characters in Excel with Functions"]
[]
[null,"Using SUBSTITUTE Function to Replace Special Characters",null,null,null,null,null,null,null,null,null,null,null,null,"Practice Here"]
[]
[null,"Product","Invalid Product Codes",null,"Corrected Product Codes",null,null,null,null,null,null,null,null,null,"Product","Invalid Product Codes",null,"Corrected Product Codes"]
[null,"Eraser","™4227™",null,{"$f":"SUBSTITUTE(C6,\"™\",\"\")","v":"4227"},null,"<< Input formula in these cells.",null,null,null,null,null,null,null,"Eraser","™4227™"]
[null,"Ruler","™4™685",null,{"$f":"SUBSTITUTE(C7,\"™\",\"\")","v":"4685"},null,null,null,null,null,null,null,null,null,"Ruler","™4™685"]
[null,"Gel Pen","™3021",null,"3021",null,null,null,null,null,null,null,null,null,"Gel Pen","™3021"]
[null,"Fountain Pen","™3196™™™",null,"3196",null,null,null,null,null,null,null,null,null,"Fountain Pen","™3196™™™"]
[null,"B2 Pencil","™4™356",null,"4356",null,null,null,null,null,null,null,null,null,"B2 Pencil","™4™356"]
[null,"B3 Pencil","™49™31",null,"4931",null,null,null,null,null,null,null,null,null,"B3 Pencil","™49™31"]
[null,"Sharpener","™3953™",null,"3953",null,null,null,null,null,null,null,null,null,"Sharpener","™3953™"]
[]
[null,"Note: If you want to replace \"?\" with single quote ', then type '' inside cell C6. Writing single quote once, change the cell format to text format only. One ' in cell C6 will not act as a replacing character here."]

{"sheet":"3.2 Nested SUBSTITUTE","index":6,"n_rows":15,"n_cols":15,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
[null,"How to Replace Special Characters in Excel with Functions"]
[]
[null,"Using Nested SUBSTITUTE Function to Replace Multiple Characters",null,null,null,null,null,null,null,null,null,"Practice Here"]
[]
[null,"Product","Invalid Product Codes",null,"Corrected Product Codes",null,null,null,null,null,null,"Product","Invalid Product Codes",null,"Corrected Product Codes"]
[null,"Eraser","™4227©",null,{"$f":"SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(C6,\"©\",\"\"),\"®\",\"\"),\"™\",\"\")","v":"4227"},"<< Input formula in these cells.",null,null,null,null,null,"Eraser","™4227©"]
[null,"Ruler","®4685™",null,{"$f":"SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(C7,\"©\",\"\"),\"®\",\"\"),\"™\",\"\")","v":"4685"},null,null,null,null,null,null,"Ruler","®4685™"]
[null,"Gel Pen","™3021",null,"3021",null,null,null,null,null,null,"Gel Pen","™3021"]
[null,"Fountain Pen","319™6",null,"3196",null,null,null,null,null,null,"Fountain Pen","319™6"]
[null,"B2 Pencil","43™5™6",null,"4356",null,null,null,null,null,null,"B2 Pencil","43™5™6"]
[null,"B3 Pencil","©4931™",null,"4931",null,null,null,null,null,null,"B3 Pencil","©4931™"]
[null,"Sharpener","395®3™",null,"3953",null,null,null,null,null,null,"Sharpener","395®3™"]
[]
[null,"Note: If you have numerous characters to replace, then"]
[null,"LAMBDA is a better alternative."]

{"sheet":"3.3 REPLACE","index":7,"n_rows":12,"n_cols":14,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
[null,"How to Replace Special Characters in Excel with Functions"]
[]
[null,"Use REPLACE Function to Replace Characters from a Specified Position",null,null,null,null,null,null,null,null,"Practice Here"]
[]
[null,"Product","Invalid Product Codes",null,"Corrected Product Codes",null,null,null,null,null,"Product","Invalid Product Codes",null,"Corrected Product Codes"]
[null,"Eraser","™™4227",null,{"$f":"REPLACE(C6,1,1,\"\")","v":"™4227"},"<< Input formula in these cells.",null,null,null,null,"Eraser","™™4227"]
[null,"Ruler","™™4685",null,{"$f":"REPLACE(C7,1,1,\"\")","v":"™4685"},null,null,null,null,null,"Ruler","™™4685"]
[null,"Gel Pen","™™3021",null,"™3021",null,null,null,null,null,"Gel Pen","™™3021"]
[null,"Fountain Pen","™™3196",null,"™3196",null,null,null,null,null,"Fountain Pen","™™3196"]
[null,"B2 Pencil","™™4356",null,"™4356",null,null,null,null,null,"B2 Pencil","™™4356"]
[null,"B3 Pencil","™™4931",null,"™4931",null,null,null,null,null,"B3 Pencil","™™4931"]
[null,"Sharpener","™™3953",null,"™3953",null,null,null,null,null,"Sharpener","™™3953"]

{"sheet":"4. Special Char with Criteria","index":8,"n_rows":12,"n_cols":14,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
[null,"How to Replace Special Characters in Excel with Functions"]
[]
[null,"Replace Characters That Are Not Numbers",null,null,null,null,null,null,null,null,"Practice Here"]
[]
[null,"Product","Invalid Product Codes",null,"Corrected Product Codes",null,"Corrected Product Codes Keeping # Characters",null,null,null,"Product","Invalid Product Codes",null,"Corrected Product Codes"]
[null,"Eraser","™Ÿ4227#",null,{"$f":"_xlfn.TEXTJOIN(\"\",TRUE,IF(((CODE(MID(C6,_xlfn.SEQUENCE(LEN(C6)),1)))<=57*(CODE(MID(C6,_xlfn.SEQUENCE(LEN(C6)),1))>=48))*1,MID(C6,_xlfn.SEQUENCE(LEN(C6)),1),REPLACE(MID(C6,_xlfn.SEQUENCE(LEN(C6)),1),1,1,\"\")))","v":"4227"},null,{"$f":"_xlfn.TEXTJOIN(\"\",TRUE,IF((((CODE(MID(C6,_xlfn.SEQUENCE(LEN(C6)),1)))<=57*(CODE(MID(C6,_xlfn.SEQUENCE(LEN(C6)),1))>=48))+(CODE(MID(C6,_xlfn.SEQUENCE(LEN(C6)),1))=35))*1,MID(C6,_xlfn.SEQUENCE(LEN(C6)),1),REPLACE(MID(C6,_xlfn.SEQUENCE(LEN(C6)),1),1,1,\"\")))","v":"4227#"},null,null,null,"Eraser","™™4227"]
[null,"Ruler","›468Ÿ5",null,{"$f":"_xlfn.TEXTJOIN(\"\",TRUE,IF(((CODE(MID(C7,_xlfn.SEQUENCE(LEN(C7)),1)))<=57*(CODE(MID(C7,_xlfn.SEQUENCE(LEN(C7)),1))>=48))*1,MID(C7,_xlfn.SEQUENCE(LEN(C7)),1),REPLACE(MID(C7,_xlfn.SEQUENCE(LEN(C7)),1),1,1,\"\")))","v":"4685"},null,{"$f":"_xlfn.TEXTJOIN(\"\",TRUE,IF((((CODE(MID(C7,_xlfn.SEQUENCE(LEN(C7)),1)))<=57*(CODE(MID(C7,_xlfn.SEQUENCE(LEN(C7)),1))>=48))+(CODE(MID(C7,_xlfn.SEQUENCE(LEN(C7)),1))=35))*1,MID(C7,_xlfn.SEQUENCE(LEN(C7)),1),REPLACE(MID(C7,_xlfn.SEQUENCE(LEN(C7)),1),1,1,\"\")))","v":"4685"},null,null,null,"Ruler","™™4685"]
[null,"Gel Pen","3©021¢",null,{"$f":"_xlfn.TEXTJOIN(\"\",TRUE,IF(((CODE(MID(C8,_xlfn.SEQUENCE(LEN(C8)),1)))<=57*(CODE(MID(C8,_xlfn.SEQUENCE(LEN(C8)),1))>=48))*1,MID(C8,_xlfn.SEQUENCE(LEN(C8)),1),REPLACE(MID(C8,_xlfn.SEQUENCE(LEN(C8)),1),1,1,\"\")))","v":"3021"},null,{"$f":"_xlfn.TEXTJOIN(\"\",TRUE,IF((((CODE(MID(C8,_xlfn.SEQUENCE(LEN(C8)),1)))<=57*(CODE(MID(C8,_xlfn.SEQUENCE(LEN(C8)),1))>=48))+(CODE(MID(C8,_xlfn.SEQUENCE(LEN(C8)),1))=35))*1,MID(C8,_xlfn.SEQUENCE(LEN(C8)),1),REPLACE(MID(C8,_xlfn.SEQUENCE(LEN(C8)),1),1,1,\"\")))","v":"3021"},null,null,null,"Gel Pen","™™3021"]
[null,"Fountain Pen","#3196©",null,{"$f":"_xlfn.TEXTJOIN(\"\",TRUE,IF(((CODE(MID(C9,_xlfn.SEQUENCE(LEN(C9)),1)))<=57*(CODE(MID(C9,_xlfn.SEQUENCE(LEN(C9)),1))>=48))*1,MID(C9,_xlfn.SEQUENCE(LEN(C9)),1),REPLACE(MID(C9,_xlfn.SEQUENCE(LEN(C9)),1),1,1,\"\")))","v":"3196"},null,{"$f":"_xlfn.TEXTJOIN(\"\",TRUE,IF((((CODE(MID(C9,_xlfn.SEQUENCE(LEN(C9)),1)))<=57*(CODE(MID(C9,_xlfn.SEQUENCE(LEN(C9)),1))>=48))+(CODE(MID(C9,_xlfn.SEQUENCE(LEN(C9)),1))=35))*1,MID(C9,_xlfn.SEQUENCE(LEN(C9)),1),REPLACE(MID(C9,_xlfn.SEQUENCE(LEN(C9)),1),1,1,\"\")))","v":"#3196"},null,null,null,"Fountain Pen","™™3196"]
[null,"B2 Pencil","4Ÿ356«",null,{"$f":"_xlfn.TEXTJOIN(\"\",TRUE,IF(((CODE(MID(C10,_xlfn.SEQUENCE(LEN(C10)),1)))<=57*(CODE(MID(C10,_xlfn.SEQUENCE(LEN(C10)),1))>=48))*1,MID(C10,_xlfn.SEQUENCE(LEN(C10)),1),REPLACE(MID(C10,_xlfn.SEQUENCE(LEN(C10)),1),1,1,\"\")))","v":"4356"},null,{"$f":"_xlfn.TEXTJOIN(\"\",TRUE,IF((((CODE(MID(C10,_xlfn.SEQUENCE(LEN(C10)),1)))<=57*(CODE(MID(C10,_xlfn.SEQUENCE(LEN(C10)),1))>=48))+(CODE(MID(C10,_xlfn.SEQUENCE(LEN(C10)),1))=35))*1,MID(C10,_xlfn.SEQUENCE(LEN(C10)),1),REPLACE(MID(C10,_xlfn.SEQUENCE(LEN(C10)),1),1,1,\"\")))","v":"4356"},null,null,null,"B2 Pencil","™™4356"]
[null,"B3 Pencil","49©31¥¥¥",null,{"$f":"_xlfn.TEXTJOIN(\"\",TRUE,IF(((CODE(MID(C11,_xlfn.SEQUENCE(LEN(C11)),1)))<=57*(CODE(MID(C11,_xlfn.SEQUENCE(LEN(C11)),1))>=48))*1,MID(C11,_xlfn.SEQUENCE(LEN(C11)),1),REPLACE(MID(C11,_xlfn.SEQUENCE(LEN(C11)),1),1,1,\"\")))","v":"4931"},null,{"$f":"_xlfn.TEXTJOIN(\"\",TRUE,IF((((CODE(MID(C11,_xlfn.SEQUENCE(LEN(C11)),1)))<=57*(CODE(MID(C11,_xlfn.SEQUENCE(LEN(C11)),1))>=48))+(CODE(MID(C11,_xlfn.SEQUENCE(LEN(C11)),1))=35))*1,MID(C11,_xlfn.SEQUENCE(LEN(C11)),1),REPLACE(MID(C11,_xlfn.SEQUENCE(LEN(C11)),1),1,1,\"\")))","v":"4931"},null,null,null,"B3 Pencil","™™4931"]
[null,"Sharpener","«™3953™",null,{"$f":"_xlfn.TEXTJOIN(\"\",TRUE,IF(((CODE(MID(C12,_xlfn.SEQUENCE(LEN(C12)),1)))<=57*(CODE(MID(C12,_xlfn.SEQUENCE(LEN(C12)),1))>=48))*1,MID(C12,_xlfn.SEQUENCE(LEN(C12)),1),REPLACE(MID(C12,_xlfn.SEQUENCE(LEN(C12)),1),1,1,\"\")))","v":"3953"},null,{"$f":"_xlfn.TEXTJOIN(\"\",TRUE,IF((((CODE(MID(C12,_xlfn.SEQUENCE(LEN(C12)),1)))<=57*(CODE(MID(C12,_xlfn.SEQUENCE(LEN(C12)),1))>=48))+(CODE(MID(C12,_xlfn.SEQUENCE(LEN(C12)),1))=35))*1,MID(C12,_xlfn.SEQUENCE(LEN(C12)),1),REPLACE(MID(C12,_xlfn.SEQUENCE(LEN(C12)),1),1,1,\"\")))","v":"3953"},null,null,null,"Sharpener","™™3953"]

{"sheet":"5. LAMBDA","index":9,"n_rows":15,"n_cols":13,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
[null,"How to Replace Special Characters in Excel Using LAMBDA Function"]
[]
[null,"Replace a Specified Set of Characters",null,null,null,null,null,null,null,"Practice Here"]
[]
[null,"Characters to Replace",null,null,null,null,null,null,null,"Characters to Replace"]
[null,"€ ‹ › © ™ ¥ £ ® « » ¢","<< Add any chararcter you want to replace with the existing characters.",null,null,null,null,null,null,"€ ‹ › © ™ ¥ £ ® « » ¢"]
[]
[null,"Product","Invalid Product Codes",null,"Corrected Product Codes",null,null,null,null,"Product","Invalid Product Codes",null,"Corrected Product Codes"]
[null,"Eraser","‹4227›",null,{"$f":"ReplaceChars(C9,$B$6)","v":"4227"},"=ReplaceChars(C9,$B$6)",null,null,null,"Eraser","‹4227›"]
[null,"Ruler","«4»685",null,{"$f":"ReplaceChars(C10,$B$6)","v":"4685"},null,null,null,null,"Ruler","«4»685"]
[null,"Gel Pen","€3021€®",null,{"$f":"ReplaceChars(C11,$B$6)","v":"3021"},null,null,null,null,"Gel Pen","€3021€®"]
[null,"Fountain Pen","¢3196™",null,{"$f":"ReplaceChars(C12,$B$6)","v":"3196"},null,null,null,null,"Fountain Pen","¢3196™"]
[null,"B2 Pencil","£4356©",null,{"$f":"ReplaceChars(C13,$B$6)","v":"4356"},null,null,null,null,"B2 Pencil","£4356©"]
[null,"B3 Pencil","»4931",null,{"$f":"ReplaceChars(C14,$B$6)","v":"4931"},null,null,null,null,"B3 Pencil","»4931"]
[null,"Sharpener","«3953",null,{"$f":"ReplaceChars(C15,$B$6)","v":"3953"},null,null,null,null,"Sharpener","«3953"]

{"sheet":"6. VBA","index":10,"n_rows":15,"n_cols":14,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
[null,"How to Replace Special Characters in Excel"]
[]
[null,"Use VBA Codes to Replace a Specified Set of Characters",null,null,null,null,null,null,null,null,"Practice Here"]
[]
[null,"Characters to Replace",null,null,null,null,null,null,null,null,"Characters to Replace"]
[null,"€ ‹ › © ™ ¥ £ ® « » ¢","<< Add any chararcter you want to replace with the existing characters.",null,null,null,null,null,null,null,"€ ‹ › © ™ ¥ £ ® « » ¢"]
[]
[null,"Product","Invalid Product Codes",null,"Corrected Product Codes",null,null,null,null,null,"Product","Invalid Product Codes",null,"Corrected Product Codes"]
[null,"Eraser","‹4227",null,{"$f":"ReplaceUnwantedChars(C9,$B$6)","v":"#4227"},"=RemoveUnwantedChars(C9,$B$6)",null,null,null,null,"Eraser","‹4227"]
[null,"Ruler","›4685",null,{"$f":"ReplaceUnwantedChars(C10,$B$6)","v":"#4685"},null,null,null,null,null,"Ruler","›4685"]
[null,"Gel Pen","©3021",null,{"$f":"ReplaceUnwantedChars(C11,$B$6)","v":"#3021"},null,null,null,null,null,"Gel Pen","©3021"]
[null,"Fountain Pen","™3196",null,{"$f":"ReplaceUnwantedChars(C12,$B$6)","v":"#3196"},null,null,null,null,null,"Fountain Pen","™3196"]
[null,"B2 Pencil","®4356",null,{"$f":"ReplaceUnwantedChars(C13,$B$6)","v":"#4356"},null,null,null,null,null,"B2 Pencil","®4356"]
[null,"B3 Pencil","«4931",null,{"$f":"ReplaceUnwantedChars(C14,$B$6)","v":"#4931"},null,null,null,null,null,"B3 Pencil","«4931"]
[null,"Sharpener","^3953",null,{"$f":"ReplaceUnwantedChars(C15,$B$6)","v":"^3953"},null,null,null,null,null,"Sharpener","^3953"]

{"sheet":"Nonwritable Chars","index":11,"n_rows":9,"n_cols":15,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
[null,"How to Replace Characters Which You Cannot Type in Excel"]
[]
[null,"Using CHAR and CODE Functions with SUBSTITUTE Function",null,null,null,null,null,null,null,null,null,"Practice Here"]
[]
[null,"Product","Invalid Product Codes","Character Code of §","Corrected Product Codes",null,null,null,null,null,null,"Product","Invalid Product Codes",null,"Corrected Product Codes"]
[null,"Eraser","4227§",{"$f":"CODE(RIGHT(C6))","v":167},{"$f":"SUBSTITUTE(C6,CHAR(167),\"\")","v":"4227"},{"$f":"_xlfn.FORMULATEXT(E6)","v":"=SUBSTITUTE(C6,CHAR(167),\"\")"},null,null,null,null,null,"Eraser","™4227©"]
[null,"Ruler","4§685",{"$f":"\"^\"&_xlfn.FORMULATEXT(D6)","v":"^=CODE(RIGHT(C6))"},{"$f":"SUBSTITUTE(C7,CHAR(167),\"\")","v":"4685"},null,null,null,null,null,null,"Ruler","®4685™"]
[null,"Gel Pen","§3021",null,"3021",null,null,null,null,null,null,"Gel Pen","™3021"]
[null,"Fountain Pen","31§96",null,"3196",null,null,null,null,null,null,"Fountain Pen","319™6"]

{"sheet":"Foreign Characters","index":12,"n_rows":12,"n_cols":8,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
[null,"How to Replace Special Characters in Excel"]
[]
[null,"Use a VBA Code to Replace Foreign Characters with English Letters",null,null,null,null,"Practice Here"]
[]
[null,"Spelling in Spanish","Spelling in English",null,null,null,"Spelling in Spanish","Spelling in English"]
[null,"área",{"$f":"AccReplace(B6)","v":"area"},{"$f":"_xlfn.FORMULATEXT(C6)","v":"=AccReplace(B6)"},null,null,"área"]
[null,"équivalence",{"$f":"AccReplace(B7)","v":"equivalence"},null,null,null,"équivalence"]
[null,"ébola",{"$f":"AccReplace(B8)","v":"ebola"},null,null,null,"ébola"]
[null,"ítem",{"$f":"AccReplace(B9)","v":"item"},null,null,null,"ítem"]
[null,"‎Ñaño",{"$f":"AccReplace(B10)","v":"‎Nano"},null,null,null,"‎Ñaño"]
[null,"ópera",{"$f":"AccReplace(B11)","v":"opera"},null,null,null,"ópera"]
[null,"argüe",{"$f":"AccReplace(B12)","v":"argue"},null,null,null,"argüe"]

{"sheet":"Non-Printable Chars","index":13,"n_rows":12,"n_cols":11,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
[null,"How to Remove Non-Printable Characters in Excel"]
[]
[null,"Use CLEAN and TRIM Functions",null,null,null,null,null,"Practice Here"]
[]
[null,"Product","Invalid Product Codes",null,"Corrected Product Codes",null,null,"Product","Invalid Product Codes",null,"Corrected Product Codes"]
[null,"Eraser","    42\n27",null,{"$f":"TRIM(CLEAN(C6))","v":"4227"},null,null,"Eraser","    42\n27"]
[null,"Ruler","\u000b4685",null,{"$f":"TRIM(CLEAN(C7))","v":"4685"},null,null,"Ruler","\u000b4685"]
[null,"Gel Pen","3021\u0007",null,"3021",null,null,"Gel Pen","3021\u0007"]
[null,"Fountain Pen","\f3196\f",null,"3196",null,null,"Fountain Pen","\f3196\f"]
[null,"B2 Pencil","43\u000f56",null,"4356",null,null,"B2 Pencil","43\u000f56"]
[null,"B3 Pencil","\u000b 4931",null,"4931",null,null,"B3 Pencil","\u000b 4931"]
[null,"Sharpener","39\f\f53",null,"3953",null,null,"Sharpener","39\f\f53"]