Thread
: [Solved]
From Excel column to coma
View Single Post
04-15-2010, 09:59 PM
Chaitanya_Sagar
Windows Vista
Office 2007
Novice
Join Date: Nov 2009
Posts: 6
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
Chaitanya_Sagar
View Public Profile
Visit Chaitanya_Sagar's homepage!
Find all posts by Chaitanya_Sagar