Ignore special symbol read from excel

How do i ignore special symbols, when reading from excel?
E.g.  with a question mark inside, bot read as .

Hi @TyraS

You can Try with replace function!

Currentrow(“YourColumnValue”).ToString.Replace(“YourSymbol”,"")

Regards

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