Join text-strings and send to clipboard

[massai]

I have created an address list in excel and want to join all the e-mail addresses in one cell (separated by commas) so I can copy/paste it into my webmail. I can do that with the CONCATENATE-function, but that doesn’t enable me to copy/paste the content of the cell. I only get the formula copied to the clipboard, but I want the content that is showed in the cell and not the formula.

Can anyone help?

[dominicb]

Good morning massai

...and welcome to the forum!!

The easiest way to do this (easy-not resorting to VBA and writing a routine to do the job) would be to copy the cell, then paste it into any empty cell using <right click>, Paste Special, then select Values under the Paste option and click OK. Then copy again, and paste it into your e-mail client.

Like I say, it's a bit scrappy, but it'll work.

HTH

DominicB

[massai]

Thanks!
That's just what I needed!