Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Shrink text and return characters
The result of my formula will either be a single character or 9 characters
long. If it results in 1 character, my font in size 10 and everything is how I want it. If it results in 9 characters, I would like the font to shrink to fit (approximately font size 6) and wrap with 3 characters then a return, then 3 more characters, then another return, then the last three characters. I cannot get it to work with both shrink to fit, and wrap text. When I manually insert return characters or use a formula that results in or points to a return character, Excel changes the cell formula from shrink to fit to wrap. Is there any way to achive this result without using VBA? Thanks, |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I return characters from within brackets? | Excel Discussion (Misc queries) | |||
Custom filter will not return characters between 1-9 inclusive | Excel Discussion (Misc queries) | |||
shrink to fit and wrap text | Excel Worksheet Functions | |||
Return first 'n' characters | Excel Worksheet Functions | |||
How to return # characters based on 2nd instance of value | Excel Worksheet Functions |