wrapping text from a fomula

  • Thread starter Thread starter akinovice
  • Start date Start date
A

akinovice

Hi i am using an IF statement to chose to display text from different cells
and the problem is the text is displayed fine but i can not wrap the text
using the wrap funtion and so i have to change the cell size manually.
however since the length text which gets displayed can change this option is
not useful. i want it to automatically change the size of the cell regardless
of length of text (20 words max). Also when i manually type in the text and
do not use a function the text wraps fine. Any ideas would be much
appreciated!
 
Experiment with =IF(A1>0,"abc"&CHAR(10)&"xyz","")
You will need to format the cell to allow text wrap (Format | Cells |
Alignment | check Wrap Text box
best wishes
 
Thank you very much for your reply. I am sorry Bernard but i do not
understand what you are saying? my text wrapping is working fine but when
using imported text from a formula it sops working. how will your formula
below change this?
 
Did you try Bernard's formula?

The CHAR(10) adds an internal line-feed.

Have you got the row set to "Autofit" along with "Wrap Text".


Gord Dibben MS Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

wrapped text in cells not displaying 2
text wont wrap 2
Wrapping text with line breaks problem 1
Wrapping text 2
How to control row height and text wrap in non-merged cell ??? 2
Cells ignore Wrap Text formatting! 2
Auto Row Height with Wrapped Text in Merged Cells Problem 3
Text not wrapping within a cell 1

Back
Top