ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Shrink text and return characters (https://www.excelbanter.com/excel-discussion-misc-queries/146750-shrink-text-return-characters.html)

sb1920alk

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,


All times are GMT +1. The time now is 02:45 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com