Wrap Text Evenly in Cell
This formula (in sections for readability)
puts a line-feed after each slash (/):
=SUBSTITUTE(ROUND(INDEX(Trend,$A7,3),3)*100&"% Avg / "&
ROUND(INDEX(Trend),$A7,5),3)*100&"% Man / "&
ROUND(INDEX(Trend),$A7,6),3)*100&"% Net","/","/"&CHAR(10))
Remember to format the cell(s) to allow text wrap
and to adjust the column width and row height, if necessary.
Is that something you can work with?
--------------------------
Regards,
Ron
Microsoft MVP (Excel)
(XL2003, Win XP)
"Native" wrote in message
...
Hello,
I have the following formula:
=ROUND(INDEX(Trend,$A7,3),3)*100&"% Avg / "&ROUND(INDEX(Trend),$A7,5),
3)*100&"% Man / "&ROUND(INDEX(Trend),$A7,6),3)*100&"% Net"
Which I'd like to wrap after ever "/" in the cell.
For example, instead of what you see in the cell appearing like this:
__________________
5.6% Avg / 7.2% Man
/ 12.5% Net
__________________
I'd like it to appear like this in one cell:
_________________
5.6% Avg /
7.2% Man /
12.5% Net
__________________
Any suggestions?
|