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 |
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 |
All times are GMT +1. The time now is 03:48 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com