e-mails in calc spreadsheet can't be copied and pasted into g-mail

[Bushpig]

Second and subsequent e-mail addresses in calc spreadsheet can’t be copied and pasted into g-mail. Any idea why?

[JohnSUN]

Is it formatted as hyperlink? Select cell, press Ctrl+M or choose Format - Clear Direct Formatting. and try again Copy-Paste