Try Copy & pasting this formula in the cell where you want the answer to appear:
=A1&", "&A2&", "&A3&", "&A4
In case you need details:
Highlight above text.
Click on the above menu: Edit....Copy
Open your Excel document.
Click once where you want the answer to be.
Then hit the enter key on the keyboard.
This assumes your data is in cell A1 A2 A3 A4
If you do need to go down 100 rows, cut n paste within the formula itself and change the numbers, if ya know what I mean.
This'll get ya started anyway.
I just read Merigold00's answer,
and she has a great answer for dealing with lots of rows!
Excel Guru to many.
· 1 decade ago