How to clear the unwanted characters from my rows in excel sheet?

Hello @ydash999

you can do as below.

All the unwanted symbols are added in the below regex. If you want to add more symbols you can directly add it in the expression.

System.Text.RegularExpressions.Regex.Replace(Str, “([`…:>(!“”/-])”, “”)


image
image
ExcelAutomationDemo.zip (77.1 KB)

1 Like