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?
|