Need to remove zero in excel

[vaish]

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.

[NIVED_NAMBIAR]

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