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

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