Hello, 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]

Hi, Can you try as the following? [image] The condition is as the following in Advaned Editor CurrentRow("EmployeeID").ToString.IsNumeric() = false Regards,

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

vielesh (Vielesh) January 12, 2023, 9:39pm 3

Thank you!

Cheers

1 Like

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