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

Help StudioX
,
1

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

2

Hi,

Can you try as the following?

image
image990×605 32.6 KB

The condition is as the following in Advaned Editor

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

Regards,

3

Thank you!

Cheers

1 Like
4

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