Forum Discussion
Excel Formula Character Limit
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
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.
- Hello! I am shure that someone here as @Sergej Balkan can help to shorten down your formula. Give hin pls a pm. Greets, Eva
