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
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
PacketMon Components are not loading in WAC 1909
HotCakeX in Windows Admin Center on
2 Replies