Need to remove zero in excel

Hi,

I have a excel which has data
A2 123467
A3 0
A4 12340
A5 0
Now i need to remove zeros and move to different excel.
excepted outp: 12367
12340
i tried with filter data. with remove condition
As column number contains “0” but I am not getting excepted ot.
Can anyone please help me out.

Hi @vaish

Iterate through each row values and using string replace replace zero with “”

Hope it works

Mark it as solution if you got it

Regards

Nived N :robot:

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