Forum Discussion
Excel Footer Character Limit
I have a footer which is well under the 250 character limit but I receive an error message that "the text string you entered is too long" when I bold a few words. Does anyone know why this happens? And is there something we can do to fix/work round this?
The character count is currently 129 and I have no header, I'm using rows repeated across pages for that.
6 Replies
av_church This is due to the fact that making the word limit bold, behind the scenes changes the information in the header to:
&"Calibri,Bold"limit&"Calibri,Regular"
So instead of 5 characters, limit now contributes 38 characters to the header.Holy crap, this was the problem all along! What is really weird is that it takes my bold & italicization when I use Calibri, but when I switch to Arial it triggers the limit. Why would a font name with less characters trigger it when Calibri does not? Is it just a default font setting I can change to unlock more characters when I use bold/italicize in my footers?
Smizles If I open a new tab and enter the text 'test' as the left header, this is what the header actually contains: 'test'.
If I change the font of the header to -say- Arial, the header now contains:
'&"Arial,Regular"test'.
16 characters are added to the header, just by setting it to a Font different from the default setting.
JKPieterse Thank's for explaining, looks like I will try the other suggestion of a picture with the text.
