Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 2 of 2

Thread: extra characters in list

  1. #1
    New Member
    Join Date
    Apr 2002
    Posts
    1
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hello,
    one of our users ( using excel 2000 )is creating a contact list, she is getting extra figures in the id field, eg..100, 101, 1102, 103,1104 you get the picture. I've never seen this, can't find anything on the mskb yet..thanks, joe

  2. #2
    Board Regular
    Join Date
    Feb 2002
    Location
    Southfield,MI USA
    Posts
    2,308
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hiya Joe,

    I'm a little fuzzy on how those ID's are being inputted. Do you get these extra characters from an import file of some sort? Formula? If you can tell us how that ID field is being generated we might be able to Sherlock a preventive approach to solving the problem.

    If you're looking for a way to clean the data "after the fact" I suppose you could use a formula similar to this:

    =Right(A2,3) (to get the last 3 characters). I'm guessing somewhat based on your example of: that 1102 is meant to be 102.

    You may have to tweak the formula with an if-statement when you get ID's that are supposed to be >1000 or if you get more than an occasional extra "1" in the front of your data.

    Hope that helps a bit -more or less
    Adam

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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