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?
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
Please familiarise yourself with the rules before posting. You can find them here.
Thanks!
That's just what I needed!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks