How to turn Excel Spreadsheet back into Comma Separated

[grafx77]

How would I go about changing a row of phrases into a comma seperated list like so:

From:
abc1
abc2
abc3
abc4
abc5

To:

abc1, abc2, abc3, abc4, abc5, so on

[Bryan Hessey]

How would I go about changing a row of phrases into a comma seperated list like so:

From:
abc1
abc2
abc3
abc4
abc5

To:

abc1, abc2, abc3, abc4, abc5, so on

Hi,

assuming they are in column A, in B1 put

=A1&", "&B2

and formula fill that downwards.

Your list is in B1

hth
---

[grafx77]

Wow...that was a quick response.

Thanks for the help, it worked wonderfully.

[Bryan Hessey]

Wow...that was a quick response.

Thanks for the help, it worked wonderfully.

good to see, and thanks for the feedback.
---