Removal of unwanted characters from table

i have a table in excel which has the following characters in it


i want to remove all these strings from the table, if they exist
soo how should i do it using UiPath.

Use regex on every column and replace it with blank:
Regex - “[^0-9a-zA-Z]” --> it will only allow characters and numbers.

Syntax in UiPath: System.Text.RegularExpressions.Regex.Replace(“Your String”,"[^0-9a-zA-Z]”,"")

@Aishwarya_Bhargava
Lets assume your data is in a datatable

have a look here on replacing a value in all rows and columns
Replace_AllCellsAllRows.xaml (7.5 KB)

just change the string insed the replace method