=A1&CHAR(10)&B1

Don't forget that you will also need to set wrap text on the cell and make
the row high enough.

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)



"Alphafiction" wrote in message
...
I'm trying to insert a break at a particular point in text that is
combined
using concatenate. The text is being used as column headings and I was
hoping
to have some consistency in appearance to make the information easier to
read. The length of the pieces of combined text are of differing lengths.
The
column widths are generally the same but do occasionally vary.

Any ideas?