If Cell is Blank, Insert Other Cell

[joninmichigan]

Hello,

What formula can I use if I need to have Excel see if one cell is blank and if it is, to insert text from another cell? In the attached, if a cell from the cell phone column is blank, it should fill in the phone number from the corresponding home phone column.

Thanks!

[Gregb11]

You didn't attach a file, you just attached an image.
How is the data entered. You can't have a formula and enter data in the same cell (and keep the formula there). I guess what you could do is, say Cell Phone column is C and Home phone is in column E, you could enter in C2:
=E2
and copy it as far down as you need.
Another option is to use another column (say Column F) and in it you could have:
=IF(C2="",E2,C2)