Can an Excel file be converted to a word doc?

D

Donna

I working with a spreadsheet containing 18 cloumns of fill-in information,
ranging from basic text to general numbers and dates. I want to merge all
the information in those 18 cells, for each row, and/or save it as a word
document.
 
D

Dave Peterson

You could just build a giant formula that concatenates those 18 cells:

=a1&b1&c1&...&q1&r1

But since you have numbers, dates, times, you'd want to format those to make
them look nice:

=text(a1,"mm/dd/yyyy")& " " & b1 & " " & text(c1,"hh:mm") & " " &
text(d1,"$0.00") & " " & ..... & r1

And if you want to force new lines within that giant formula:

=text(a1,"mm/dd/yyyy")& char(10) & b1 & " " & text(c1,"hh:mm") & " " &
text(d1,"$0.00") & char(10) & ..... & r1

(remember to format the cell as wrap text)

Once you build that formula, then you could just copy down the column. And
never throw it away!
 
Top