Advanced Concatenate

You could put this (minimally-tested) function in your workbook:

Please Login or Register  to view this content.

And then use it like this:

=Cat(F2:F334, ",", TRUE)

When you hear the beep, the catenated data is on the clipboard and you can paste it wherever.

BEFORE you use the function, you have to set a reference in the VBE to Microsoft Forms 2.0 Object Library. You can either

>> find it under Tools > References in the VBE, or

>> add a form to your workbook (Insert > UserForm), and then delete it (the reference will remain).

Please mark the thread as solved?

Click the Edit button on your first post in the thread

Click Go Advanced, select [SOLVED] from the Prefix dropdown, then click Save Changes

If more than two days have elapsed since your first post, ask a moderator to mark it.

Hi, I am having a similar problem. Except I am working with numbers and I need to separate them with a space. Can I use the code above, if so can I just change "," to " ",? Also, where do I put this code? Anywhere in excel?

I am a newbie with a new job that uses excel a lot. So I will have tons of questions I am sure.
Thanks!

Welcome to the forum, naynay.

Please take a few minutes to read the Forum Rules about posting questions in other people's threads (and in general), and then start your own.

Here's a crude way to do it, but effective.

I'm assuming that you can use column G.

In G2, type "=F2" (without the quotes)
In G3, type "=G2&","&F3" (without the quotes)

Now, just copy down the formula in G3 down to G334, and the value that appears in G334 is the list you are looking for. Copy the contents of G334, and paste it in your email using paste special / values.

Done!