Excel Gradually Deletes Multiple Extraneous Plus Signs
This is kind of odd. Enter the following formula into a cell:
Sure, it's an odd formula, but it's legal. Excel accepts it and returns 21.
Next, activate the cell and press F2 to enter EDIT mode. Don't make any changes; just press Enter. The formula now appears as:
Excel removed one of the plus signs. Press F2 and Enter again, and you'll find that Excel removes another plus sign. Keep repeating it until all of the plus signs are removed and you're left with this formula:
You get different behavior if you substitute a cell reference for the constant:
In this case, Excel keeps all of the extraneous plus signs when you edit the formula.
Try this one:
With each edit, Excel removes one plus sign from each of the three groups of plus signs. But, similar to the cell reference example above, it won't modify this formula:
Contributed by Joe Rosebrock.
Excel is a complex program, and has been around for a long time. Consequently, it has many obscure nooks and crannies to discover. Some of them are described here.
Keep in mind that some versions of Excel are odder than others. In other words, the things described here may not apply to all versions of Excel.
All Odd Stuff
Browse Oddities by Category
Seen Something Odd?
If you've discovered something weird about Excel, let me know.