How to remove character in a data table

Hi! I am cleaning my data in excel and I want to remove all characters ’ in the table. Any advice on this would be appreciated.

e.g.
row 1: 123456’
row2: 345678’

If there is only one charcter then you can use

row(ColumnIndex).ToString.Replace("’",String.Empty)

thanks! i tried the same but it does not write back to the excel as a data table as it is assigned as a string.

have a look here:

Thanks for the help. This works row(ColumnIndex) = row(ColumnIndex).ToString.Replace("’",String.Empty)

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.