How do I take three/four letter acronyms from an Excel spreadsheet and put them, comma separated, in one cell?

Question

The 3/4 letter acronyms are always in one column, but the number of rows varies (could be up to 100). So A1 could be AAA and A2 could be AAB and the output in B1 would be "AAA,AAB". If there is a limit on how much information Excel can get in one cell, then it would be OK to do the next batch in another cell or cells. I am looking for some formula or macro which will do this for me completely automatically. Thanks in advance

NB I need to be able to do this for a column of up to 100 cells. The information comes in an Excel spreadsheet. The 3/4 letter acronyms are always in one column, but the number of rows varies (could be up to 100). So A1 could be AAA and A2 could be AAB and the output in B1 would be "AAA,AAB". If there is a limit on how much information Excel can get in one cell, then it would be OK to do the next batch in another cell or cells. I am looking for some formula or macro which will do this for me completely automatically. Thanks in advance

Answer 1

Concatenate the cells with this formula in B1:

=A1 & "," & A2

Answer 2

I would suggest you do that in word.
Save it as a text file, open in word, do a search and replace of the return or carriage return character using special characters menu. Your text will be in one long joined string.
Better than excel which only accepts not more than 256 characters.

Answer 3

why