Is there a limitation as to how many cells you can do
this with?
Thanks for your patience.
-----Original Message-----
Bob
In C1 enter =A1 & " " & B1
Copy C1 and(in place)Paste SpecialValueOKEsc.
Set wrap text on C1.
Delete A1 and B1 if you want to.
Gord Dibben Excel MVP
On Fri, 4 Mar 2005 09:28:18 -0800, "Bob"
wrote:
I have imported data from another application, SAP,
into
a spreadsheet. There are 2 or more cells per row that
contain text.
I want to combine them into one cell with wrapped text
to
be able to read easier or I would like to export all of
the text cells to Word without having it separated into
separate cells in word.
Any help would be appreciated.
.
|