Clear or convert special characters in Excel


How to convert or to clear the special character in excel,
please refer image below of special character.

Hi @Prasaanth_S,

  1. Try the following regural expression for each row:
System.Text.RegularExpressions.Regex.Replace((currentrow(“columnname”).tostring), “[^A-Za-z0-9-/]”, “”)
  1. Try to follow this video if you need to apply the changes into the Excel file:

Hope it helps you!

we would recommend more to invest within the analysis of the root cause of the crashed chars. In general it comes from missetting the Character encodings and can be fixed by using the right character encodings.

Could it be the case that CSV data directly / or indirectly by using several open / save action was involved. What is the very origin source of this data?