Hi,
Is it possible to write a formula in B1 which counts the elements of the formula put into A1?
Example:
A1 contains the following:
=34+142+35+50
Therefore, the formula in B1 must return 4
I was thinking one way to do it would be to count the occurrence of the + sign, and add 1 to that.
However, it all seems impossible, because Excel refuses to acknowledge the formula itself, only its product. Once the = sign goes in front of the expression, it's, well, game over man, game over. You can no longer count the parts of that formula. Or can you?
Bookmarks