Forum Discussion

av_church's avatar
av_church
Copper Contributor
Jul 24, 2019
Solved

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? A...
excel
  • PReagan's avatar
    PReagan
    Jul 24, 2019

    Hello av_church,

     

    Although not ideal, here is a workaround for that problem:

     

    https://answers.microsoft.com/en-us/msoffice/forum/all/inserting-long-text-footer-in-excel-2010/8cb67abc-c294-49c2-9bf2-a51f110b15f4

     

    Hope this helps!
    PReagan

JKPieterse's avatar
JKPieterse
Silver Contributor
Jul 24, 2019

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.

Smizles's avatar
Smizles
Copper Contributor
May 17, 2022

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?

  • JKPieterse's avatar
    JKPieterse
    Silver Contributor
    May 17, 2022

    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.

Resources