Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2002
    Location
    Bay Area
    Posts
    511

    Unanswered: Help with a Mystery

    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

  2. #2
    Join Date
    Sep 2008
    Location
    London, UK
    Posts
    511
    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!

  3. #3
    Join Date
    Jan 2002
    Location
    Bay Area
    Posts
    511
    Deleting the autocorrect rule for ... worked as you said it would. Thanks.
    Jerry

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •