automatic text copying

Mar 2nd, 2002, 12:52 AM

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 · Mar 2nd, 2002, 03:25 AM

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.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 2nd, 2002, 12:52 AM	#1
Guest Posts: n/a	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.

Mar 2nd, 2002, 03:25 AM	#2
Andy Gee New Member Join Date: Feb 2002 Posts: 48	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.