Hi
post your exact formula and the entries in your source cells

--
Regards
Frank Kabel
Frankfurt, Germany

DFM wrote:
Hi,

Already tried that with no luck. Any other ideas?

Thank you, Diane


"Frank Kabel" wrote:

Hi
format the target cell also with word wrap and it should work

--
Regards
Frank Kabel
Frankfurt, Germany

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