jamieleeuk
Board Regular
- Joined
- Feb 9, 2009
- Messages
- 99
I have data in range A6:A60, I need to copy this data into another program which requires it on one row and obviously with there being 60 rows it only pastes the first. The data also has to be split with a comma.
What I have done in the past is :
=concatenate(A1,",",A2,",",A3... A15)
as concatenate only allows me to concatenate 15 cells, I have to perform 4 or 5 different concatenate formulas and then concatenate the results.
I want to know if there's an easier way of mashing them all up together in one cell seperated by a comma other than the way I am currently going about it?
Thanks
What I have done in the past is :
=concatenate(A1,",",A2,",",A3... A15)
as concatenate only allows me to concatenate 15 cells, I have to perform 4 or 5 different concatenate formulas and then concatenate the results.
I want to know if there's an easier way of mashing them all up together in one cell seperated by a comma other than the way I am currently going about it?
Thanks