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

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