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