Wrap Text Evenly in Cell
 

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?

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?