Replacing text

[erikcmh]

Sure could use some help. I would like to set up a way so that, for example, when you type "x" into C1 it will replace the text in A1 and B1 with a zero.

By the way, I'm doing this on a PocketPC with Pocket Excel, which does not allow macros or contain all of the formulas of normal Excel.

Thanks.

[Domenic]

Enter the following formula in cell A1 and B1...

=IF(C1="x",0,"")

...which will leave A1 and B1 blank if C1 does not contain the text value 'x'.

Hope this helps!

[erikcmh]

I already have typed in text in A1 and B1, so I can't put a formula in those cells.

[Domenic]

Then how about...

=IF(C1="x",0,"TypeYourTextHere")

This way, unless C1 contains 'x', your text will be displayed.

[erikcmh]

No, that won't work either. The text in A1 and B1 would change all the time, and this is really just an example because I have about 15 fields I would like to zero out.