I have over 6,000 cells in a column that I need to join together with a comma (no spaces) between each one. Any easy ways of doing this?
I tried following these instructions, but it tells me that I am over the character limit once I press F9.
Select cell B2.
Type =A1:A6282&", " in formula bar.
Press F9.
Delete curly brackets in formula bar.
Delete last delimiting character.
Type =Concatenate( in front of all characters in formula bar.
Type ) after last character in formula bar.
Press Enter
Bookmarks