How do you convert verical items in one text box to another textbox in horizontally?

[BlazingPig]

There are a lot of times I have to copy entire column from excel sheet and then change every one of them to horizontal lines in , between in order to pull search result of them from database at once.

Content in textBox1
10001
10002
10003
10004
10005

I want convert that to


Content in textBox2
10001, 10002, 10003, 10004, 10005

How do I achieve such a feat? I am trying to make windows form and copy paste column items(from external excel column, of course) to multi-line textbox1 and with press of button, it converts EX1 to EX2 and display on textbox2.

Thanks in advance.

Continue reading...