need some formula

[Ron99]

Hi,

I have done this before but have forgotten

i have list for example

vik0wers
sa0234
wqert0w

I want a formula where it identifies "0" (zero), removes it and gives me the rest of the word, in a word zero can be anywhere
output that i expect is

vikwers
sa234
wqertw


Regards,
Vikas

 

[VoG]

Try

=SUBSTITUTE(A1,"0","")

 

[JackDanIce]

Try:

=SUBSTITUTE(A1,"0","")

 

[Ron99]

OMG....I have forgotten a simple formula

Thank you guys....for the quick reply