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?

Thanks.
Jerry

Hi Jerry,

Excel's autocorrect feature is changing the ... to ASCII 133.

You can stop this by:

Tools > Autocorrect Options
Untick "Replace text as you type" (or delete that particular rule in the listbox)

Then type in ... in a cell and repeat the process you described.

Hopefully mystery solved!

Deleting the autocorrect rule for ... worked as you said it would. Thanks.
Jerry