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

Help StudioX

system (system) Closed January 15, 2023, 9:40pm 4

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

Topic		Replies	Views
Studio X is not recognizing excel values as numerical StudioX studiox , question	1	477	January 13, 2023
How to change all cell values that do not equal "Complete" to "In Complete" using Studio X StudioX datatable , excel , studiox , question	5	777	December 14, 2022
Removing Strings from DataTable and putting Numeric all in one column Studio	3	744	May 19, 2022
I have column with mixture of Integer and Text values, i need to delete only text in a row and keep integer rows, how can i do it? Activities excel , activities , question	11	995	September 10, 2021
Remove the Rows contains Only Integer value Studio datatable , excel , studio , question , command_palette	7	1663	March 4, 2022

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

Related topics