Simple formula to copy text

[Sheizageek]

I have a spreadsheet with 67k lines of data. I need a formula, for example, that would look at A1 and if there is a name (any name) then copy their email in B1 to C1.

I am having to manually move a second email address to column C and a formula would greatly expedite this for me.

Thanks for any help.

Sharron

 

[MountainFog]

Paste in C1, then autofill down

=IF($A1<>"",B1,"")

 

[Sheizageek]

Thank you so much!