"Auto" Concatenate

Hi Guys,

I;m pretty sure I;ve seen this done before. I use the concatenate function like this:
=A4&", "&A5

however, this list i have to concatenate is getting to 40+cells, is there any way to automatically select a list to concatenate or anything.

i have a column of over 40 cells, no set number as it's different lists all the time, and need them all to appear like: word, word, word,

Is there any way to do this?

Thanks!

Thanks, that looks great, is there any way to do it without the add-in, i'm doing it from work and they're super strict about downloading?

Hi, thanks for that code, i was scared to try as i'm not very good with macro's so just been doing it the old fashioned way.

However i got to the end of my tether and gave it a go and hey presto! the best timesaver for me so far!

This link is no longer good - can you post an example of this UDF?

I googled for "MCONCAT UDF", which resulted in references to ACONCAT, which led to the following:

Please Login or Register  to view this content.