SOLVED
Home

Excel Footer Character Limit

%3CLINGO-SUB%20id%3D%22lingo-sub-771619%22%20slang%3D%22en-US%22%3EExcel%20Footer%20Character%20Limit%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-771619%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20footer%20which%20is%20well%20under%20the%20250%20character%20limit%20but%20I%20receive%20an%20error%20message%20that%20%22the%20text%20string%20you%20entered%20is%20too%20long%22%20when%20I%20bold%20a%20few%20words.%20Does%20anyone%20know%20why%20this%20happens%3F%20And%20is%20there%20something%20we%20can%20do%20to%20fix%2Fwork%20round%20this%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20character%20count%20is%20currently%20129%20and%20I%20have%20no%20header%2C%20I'm%20using%20rows%20repeated%20across%20pages%20for%20that.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-771619%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-771830%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Footer%20Character%20Limit%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-771830%22%20slang%3D%22en-US%22%3E%3CP%3EHello%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F381473%22%20target%3D%22_blank%22%3E%40av_church%3C%2FA%3E%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAlthough%20not%20ideal%2C%20here%20is%20a%20workaround%20for%20that%20problem%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fanswers.microsoft.com%2Fen-us%2Fmsoffice%2Fforum%2Fall%2Finserting-long-text-footer-in-excel-2010%2F8cb67abc-c294-49c2-9bf2-a51f110b15f4%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fanswers.microsoft.com%2Fen-us%2Fmsoffice%2Fforum%2Fall%2Finserting-long-text-footer-in-excel-2010%2F8cb67abc-c294-49c2-9bf2-a51f110b15f4%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHope%20this%20helps!%3CBR%20%2F%3EPReagan%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-771834%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Footer%20Character%20Limit%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-771834%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F381473%22%20target%3D%22_blank%22%3E%40av_church%3C%2FA%3E%26nbsp%3B%3CFONT%20style%3D%22background-color%3A%20%23ffffff%3B%22%3EThis%20is%20due%20to%20the%20fact%20that%20making%20the%20word%20%3CSTRONG%3Elimit%3C%2FSTRONG%3Ebold%2C%20behind%20the%20scenes%20changes%20the%20information%20in%20the%20header%20to%3A%3CBR%20%2F%3E%26amp%3B%22Calibri%2CBold%22limit%26amp%3B%22Calibri%2CRegular%22%3CBR%20%2F%3ESo%20instead%20of%205%20characters%2C%20%3CSTRONG%3Elimit%3C%2FSTRONG%3Enow%20contributes%2038%20characters%20to%20the%20header.%3C%2FFONT%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-771862%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Footer%20Character%20Limit%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-771862%22%20slang%3D%22en-US%22%3E%3CP%3EThanks%20for%20the%20idea%2C%20I'll%20see%20what%20I%20can%20do%20with%20it%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F360420%22%20target%3D%22_blank%22%3E%40PReagan%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
av_church
New Contributor

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.

4 Replies
Solution

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/8cb6...

 

Hope this helps!
PReagan

@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.

Thanks for the idea, I'll see what I can do with it @PReagan 

@Jan Karel Pieterse Thank's for explaining, looks like I will try the other suggestion of a picture with the text.

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies