Find 0 and replace with blank/empty data

[muhammad susanto]

hello all,

i have question about using FIND and REPLACE,
how to FIND single zero number (0) and REPLACE with empty/blank data, without not replace the other zero number

for example :

100	100 (expected result)
0
1005	1005
0
30	30

<tbody>
</tbody>

thanks very much for your helping...


M.SUSANTO

 

[wigi]

Columns(1).SpecialCells(2,1).Replace "0", "", xlWhole

 

[Jonmo1]

In the Find/Replace dialogue window,
click Options and Check "Match entire cell contents"

 

[muhammad susanto]

THANKS YOU, Jonmo1, It's help me.....

 

[Jonmo1]

Glad to help, thanks for the feedback.