Is there a way to count the number of characters in an Excel formula? I tried using the LEN() function, but that only returns info on the results of the formula, not the formula itself, even if I have the formulas displayed.
I have an Excel 2007 spreadsheet that I have to save in a binary format because I am getting an error that I have a formula that has more than 8192 characters, but I can't figure out which formula it is to see if I can shorten it at all. I would prefer to save it as an regular Excel file, but I need to find this wonky formula first.
Any ideas how I can find the formula? I am guessing that the formula is so long because it links to a number of cells in other files on our network, and the entire network address got listed in the formula for each cell referenced. But this financial spreadsheet has 36,000 populated cells, a large number of them being external references, so I haven't been able to find the bad formula using old fashioned methods (i.e., actually looking for it).