automatic text copying

[Guest]

I would like to do something like the following:

type in some text in A1
have the text automatically be copied to cell g10

I can do this using a formula, but it leaves a "0" in g10 if A1 is blank. I'd prefer not to have the "0" there. Is this possible?

Thanks.

 

[Andy Gee]

This will help:
=IF(A1<>"",A1,"")

It works like this:
IF cell A1 is not equal (<>) to nothing ("") show A1 otherwise show nothing ("")

I recommend using the IF function for many things it's extremely usefull.