sirenetta1
Board Regular
- Joined
- Feb 11, 2004
- Messages
- 169
Hi all,
I have one column with text/numbers in each cell. I would like to merge the entire column into one cell with a comma separating the entries.
Right now I'm using
=B2&","&B3&","&B4&","&B5&","&B6 etc.. etc... for the entire column.
Is there a faster formula that would do this?
Thanks for your help!
I have one column with text/numbers in each cell. I would like to merge the entire column into one cell with a comma separating the entries.
Right now I'm using
=B2&","&B3&","&B4&","&B5&","&B6 etc.. etc... for the entire column.
Is there a faster formula that would do this?
Thanks for your help!