Thread: [Solved] From Excel column to coma
View Single Post
 
Old 04-15-2010, 09:59 PM
Chaitanya_Sagar Chaitanya_Sagar is offline Windows Vista Office 2007
Novice
 
Join Date: Nov 2009
Posts: 6
Chaitanya_Sagar is on a distinguished road
Default

There's another simple way to do it.

1. I assumed data is in A1, A2...
2. Write this formula in B1 =a1
3. Write this formula in B2 =A2&","&B1
4. copy b2 and paste it till the end of data
5. Tada!

Chaitanya

Reply With Quote