Concatenating Cells and seperating HELP

[mandye]

I have a column of different text fields and I need to concatenate them and separate them with a comma. Is there an easy way of dong this without having use the formula A1&","&A2&","&A3 to get the desired affecte..

I remember seeing a post a while back of someone who had developed an add-in function called, I think MCONCAT, and this seemed to be exactly what I needed. It didn't allow me to download it at the time, and i'm now desperately trying to find a working version of it or some other substitute.

Any solutions to this query would be most welcome.

[/i]

 

[Richie(UK)]

Hi mandy,

I believe MConcat is part of the MoreFunc add-in. Try here for the add-in:

http://longre.free.fr/english/index.html

and here for a description of the various functions:

http://www.rhdatasolutions.com/morefunc/

HTH

 

[mandye]

Thanks for the link but unfortunately the link to download it seems to no longer exist when I click on it.

Any more ideas?

 

[TommyGun]

Link worked just fine for me...what about a link directly to the download...Morefunc Download