How to remove all text values from numeric value column in Excel using Studio X

I am trying to remove all text values from the numeric column and then use the numeric value to replace over the text. I need the Bot to run this operation for columns E and F every time the Excel sheet is downloaded. I am using Studio X.

numeric value question


Can you try as the following?

The condition is as the following in Advaned Editor

CurrentRow("EmployeeID").ToString.IsNumeric() = false


Thank you!


1 Like

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