C
Chris Mitchell
I have a column of data where each cell contains a unique 8 digit number.
I want to be able to put all of these numbers into a single string, with
each number being separated by a ',', e.g. xxxxxxxx,yyyyyyyy,zzzzzzzz
I know I could put a ',' in an empty cell, say C5 and use
=CONCATENATE(A1,C5,A2,C5,A3,C5....)
But with 112 rows this would be time consuming and would bust the 30 text
strings that the CONCATENATE function allows.
I'm sure there must be an easier way to do this but don't know what it is.
Any suggestions gratefully received.
I want to be able to put all of these numbers into a single string, with
each number being separated by a ',', e.g. xxxxxxxx,yyyyyyyy,zzzzzzzz
I know I could put a ',' in an empty cell, say C5 and use
=CONCATENATE(A1,C5,A2,C5,A3,C5....)
But with 112 rows this would be time consuming and would bust the 30 text
strings that the CONCATENATE function allows.
I'm sure there must be an easier way to do this but don't know what it is.
Any suggestions gratefully received.