Excel - columns to one cell
I have a list of product skus in one column in excel. I have thousands of these skus that need to be combined in one cell separated by commas with no spaces. There are too many rows of data to use the concatenate function. Not sure how to get this done. Here's an example of what I'm working with but with 6,000+ more rows. I'm using Excel 2003.
A 140-12 1074-156 903-78 876-65 349-09 986-43 237-12 342-11 450-187 677-133