combining text into one cell

[gipson2011]

Hi - I'm hoping you can help this issue has been bothering me for days!


I have a data set of Master Portfolio Names with anywhere from 1 to 50 tickers that correspond. What I need to do is pull the tickers into one cell separated by commas. Also I'm working with several thousand lines of data so a simple concatenate is taking too long to re-enter the formula for each new master and edit it according the number of tickers. There has to a better way.

 

[NARAYANK991]

Hi ,


Can you just copy + paste a few items / rows / columns of data ?


Narayan

 

[Hui]

Gipson2011


Firstly, Welcome to the Chandoo.org forums


Have a look at this post on a UDF Concat

Also read the comments as there has been several variations on the original described in the comments


http://chandoo.org/wp/2008/05/28/how-to-add-a-range-of-cells-in-excel-concat/