Column to Text Excel Tips

Need to do this from excel fast. And found the simple solution from here. I copy pasted the question from that superuser here for my own documentation.

I have the task of creating a simple Excel sheet that takes an unspecified number of rows in Column A like this:


And make them into a comma-separated list in another cell that the user can easily copy and paste into another program like so:


What is the easiest way to do this?


Assuming your data starts in A1 I would put the following in column B:





You can then paste column B2 down the whole column. The last cell in column B should now be a comma separated list of column A.


Tinggalkan Balasan

Isikan data di bawah atau klik salah satu ikon untuk log in:


You are commenting using your account. Logout / Ubah )

Gambar Twitter

You are commenting using your Twitter account. Logout / Ubah )

Foto Facebook

You are commenting using your Facebook account. Logout / Ubah )

Foto Google+

You are commenting using your Google+ account. Logout / Ubah )

Connecting to %s