Delete Zero from Column 2 in Excel

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.


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

1 Like

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.

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

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

1 Like

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