Gord,

Thanks, that worked.

-----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.

.