Even though it has as a apostrophe when read range is used that won’t come and only string will be returned
But are you getting along with that apostrophe
Fine
If so we can use regular expression like this in for each row loop as you are doing now row(“yourcolumnname”) = System.Text.RegilarExpressions.Regex.Match(row(“yourcolumnname”).ToString,”\d+”).ToString
how to remove astrophe from column.I have 1 column whose name is Item and in that row I am getting this type of value='Scale,'Pencil,'Eraser.So how to remove the astrophe.
TIA