Home

Excel Formula Character Limit

sam_p
Occasional Visitor
I am trying to use a formula that is more than the maximum formula character limit. For obvious reasons it won’t work. Does anyone have a method to get around this? The formula I am trying to use is around 61,000 characters long. Unfortunately there is no other known way to produce the outcome I am trying to achieve without this formula. Can anyone help?
2 Replies
Hello! I am shure that someone here as @Sergej Balkan can help to shorten down your formula. Give hin pls a pm. Greets, Eva

I know these 2 ways to shorten a long formula: 

1. Split the formula into separate columns; or 

2. Use named formulas for the intermediate

solutions. 

Please upload your sample file so that I can give it a try. 

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