#1
|
|||
|
|||
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 |
#2
|
||||
|
||||
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 |
#3
|
|||
|
|||
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Last Number in a Column | paulrm906 | Excel | 1 | 12-05-2008 07:51 PM |
how to mix normal page with column pages | verbster | Word | 1 | 12-05-2008 10:05 AM |
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 |
Graphing in Excel - one plot many columns/pick one column | jerryjaysr | Excel | 4 | 06-29-2006 07:27 AM |