In Cell A1 type three periods
In Cell B1 type =MID(A1,1,1)
In Cell C1 type =LEN(B1)
What I expect to get is one period displayed in Cell B1.
If you get the results I do, Cell B1 will display 3 periods when you have 3 or more periods in Cell A1, and the length formula always displays 1. This odd behavior showed up in Access VBA. Is there an Excel expert that knows why this happens?