Concatenation formula loses text wrap formatting
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 |
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 |
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 |
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 |
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 |
Thank you.
I hear you on "don't use merged cells"! But you know how it is, this person is insisting... Thank you all for your quick response. Happy Holidays! Diane "Gord Dibben" wrote: 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 |
All times are GMT +1. The time now is 09:58 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com