=IF(B1="",A1,B1)
--
David Biddulph

"Erin" wrote in message
...
Is it possible to create a formula that would copy text from cell A1 to
cell
C1 if cell B1 is blank and if cell B1 has text in it to copy it to cell
C1?
If so, could someone tell me how?

Thanks,

Erin