Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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 |