Diane
Merged cells will allow "wrap text" from FormatCellsAlignment but..........
Excel has a problem auto-fitting merged cells.
You can resize manually or via Macro. Jim Rech has written
code for this.
http://groups.google.com/groups?thre...%40tkmsftngp05
Note also a recent adaptation of this code by Greg Wilson.
http://makeashorterlink.com/?P37D24B15
The best cure is DON"T USE MERGED CELLS. They cause no end of problems with
copying, pasting, sorting, filtering.
Gord Dibben Excel MVP
On Thu, 23 Dec 2004 07:27:05 -0800, DFM wrote:
Hello,
I am using XL2003 on WinXP.
I have a concatenation formula that pulls text from 2 other worksheets. All
cells involved are formatted with Merge & Center and text wrap. The result
is that the first cell brought in is formatted correctly (text wraps), the
second cell loses the wrap.
Is there any way to force the text wrapping on the results?
Thank you for any information you can provide,
Diane