Can an Excel file be converted to a word doc?
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!
Donna wrote:
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.
--
Dave Peterson
|