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