Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Export from Excell to Word
I want to export a column of cells from Excell and import it into Word but
in Word I want the column to be in a horizontal line seprating each excell cell by a comma. Ho do you do that? Thanks |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Export from Excell to Word
Hi FTS
I have just written this UDF which should solve your problem. Step1) Paste the below into a new modlue in VBA editor Function c_column(firstcell As Range) For Each cell In firstcell c_column = c_column & "," & cell.Value Next cell c_column = Mid(c_column, 2, Len(c_column)) End Function step 2) enter this function in a cell on your spreadsheet =c_column([your range]) This will join all of your cells so you can copy and paste into word HTH Simon Fts wrote: I want to export a column of cells from Excell and import it into Word but in Word I want the column to be in a horizontal line seprating each excell cell by a comma. Ho do you do that? Thanks -- -------------------- Simon - UK Email at simon22mports [ a t ] hot mail [ d ot ]com Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...excel/200610/1 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Export from Excel to Word | New Users to Excel | |||
Pleeze Help! Export Excel data into a form in a Word Doc...this one's tough! | Excel Discussion (Misc queries) | |||
can you single click to open files in word and excell? | Excel Discussion (Misc queries) | |||
Can Excel Export Data to Word Format? | Excel Discussion (Misc queries) | |||
S.O.S :importing excell data into word | Excel Discussion (Misc queries) |