View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Native Native is offline
external usenet poster
 
Posts: 17
Default 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?