Copy & Paste Issue
 

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.

=A1 & "." & B1 & E1

Don't you need something between the last name and the domain?