Copying email addresses from Excel to Gmail into the BCC line

Question

I used to be able to copy a column of email address (with a comma at the end of each) from Excel into the BCC line of a gmail message. Now when I try to copy the column of emails, only the first line copies into the BCC. Can anyone help?

Answer 1

I entered an email address with comma at end
1. in each cell in one single column (A1, A2, A3 ...)
2. in the first cell of each column (A1, B1, C1 ... )

I tried both ways by copy and pasting into BCC, CC and TO, everywhere it pastes properly.

I think you might be perforing something wrongly.