Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #3  
Old 04-15-2010, 09:59 PM
Chaitanya_Sagar Chaitanya_Sagar is offline From Excel column to coma Windows Vista From Excel column to coma 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
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
From Excel column to coma Last Number in a Column paulrm906 Excel 1 12-05-2008 07:51 PM
From Excel column to coma how to mix normal page with column pages verbster Word 1 12-05-2008 10:05 AM
From Excel column to coma How to spread column in Word Gagilence Word 1 10-15-2008 09:19 AM
Mail Merge Anchoring column layouts HWSpencer Mail Merge 0 04-25-2008 06:08 AM
From Excel column to coma Graphing in Excel - one plot many columns/pick one column jerryjaysr Excel 4 06-29-2006 07:27 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 03:52 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft