I'm having some trouble copying data to multiple cells. I have three columns:

A: First Name
B: Last Name
C: Domain Name

My formula is this:

A:A & "." & B:B & E2


The formula works and I can copy and paste but only to one cell at a time.

If I try to paste to multiple cells I get the error:

Data on the clipboard is not the same size and shape as the selected area.