Wrap Text Evenly in Cell

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Native - 29 Mar 2008 17:39 GMT

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?

Reply to this Message

Ron Coderre - 29 Mar 2008 17:48 GMT

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)

> Hello,
>
[quoted text clipped - 21 lines]
>
> Any suggestions?

Reply to this Message