Microsoft Office Forums From Excel column to coma

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 11-08-2007, 04:57 PM
saatfj saatfj is offline
Novice
From Excel column to coma
 
Join Date: Nov 2007
Posts: 1
saatfj
Default From Excel column to coma

I have an column of words in Excell...is there a way to convert it to a row where these words are separated by comas. Maybe in Word?




aaaa
aaaa convert to -----> aaaa,aaaa,aaaa,aaaa
aaaa
aaaa



Thanks
Reply With Quote
  #2  
Old 04-15-2010, 02:01 AM
scheungyyz's Avatar
scheungyyz scheungyyz is offline From Excel column to coma Windows 7 From Excel column to coma Office 2010 (Version 14.0)
Novice
 
Join Date: Apr 2010
Posts: 5
scheungyyz is on a distinguished road
Send a message via MSN to scheungyyz From Excel column to coma
Default

try this

select the column (the "aaa"s)
click [Format Cells]
Select [custom]
Type @,
Click OK

then select the cells again, CTRL C to copy
then PASTE SPECIAL
Transpose

then select that row again, paste to word
Reply With Quote
  #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
Reply

Thread Tools
Display Modes


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


All times are GMT -7. The time now is 08:18 AM.


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