copying text from one cell to another

[ltsimmons]

Hi, I want the text contents from one cell copied to another, however if the cell is blank I want the existing cell to remain blank. My formula is copying the text correctly however if the cell is blank, a zero is showing up in my cell and I want it to remain empty.
=IF(ISBLANK(Schedule!G6),Schedule!G6,Schedule!G6)
thanks in advance for your help!

[martindwilson]

That formula is the same as just =schedule!g6
You need
If(schedule!g6="","",schedule!g6)