Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I get date/time to wrap (format - wrap text doesn't work)? | Excel Discussion (Misc queries) | |||
Can not see text in Excel when cell format is set to wrap text | New Users to Excel | |||
How do I view all text in a merged cell? Wrap text is activated. | Excel Discussion (Misc queries) | |||
Why won't text in cell wrap. Cell format set to wrap. | Excel Discussion (Misc queries) | |||
Text not continuing to wrap for large block of text in Excel cell | Charts and Charting in Excel |