Delete Zero from Column 2 in Excel

Help Studio
,
1

delete_Zero
delete_Zero292×666 8.64 KB
test.xlsx (11.6 KB)

Hi All,
Could you please help me with deleting all zero value in column 2 in a excel file. I have attached the test.xlsx and screenshot for better clarification.

Please note that there are NO HEADERS available.

Thanks

2

Use datatable Filter with remove option.
Ensure excel column is not a string one

image
image278×514 7.69 KB

image
image1258×525 47.1 KB

1 Like
3

Hi
I am not able to delete 0s using this. Please also note that 0s are written in 0,00 format. Could you please assist further.

4

use filter option accordingly. instead of greater than (>) use not equal to (!=) and in value put 0,00

5

Thanks once again. I was able to fix it and it’s working.

1 Like
6

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