Results 1 to 6 of 6
  1. #1
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Yilgarn region of Toronto, Ontario
    Posts
    5,453
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Scramble words (Excel97+)

    From a client:

    "I have a column of correctly spelled words and I want to generate a second column containing these same words misspelled.
    In the column of misspellings I would want to generate (from the correctly spelled list) half into transposition errors (abcd --> abdc) and half into omission errors (abcd --> abd). "

    From me: (attached)
    Attached Files Attached Files

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Scramble words (Excel97+)

    I scrambled eggs and got just one egg <img src=/S/sad.gif border=0 alt=sad width=15 height=15>

  3. #3
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Yilgarn region of Toronto, Ontario
    Posts
    5,453
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Scramble words (Excel97+)

    >I scrambled eggs and got just one egg
    That's a design feature.
    From Homlette: Tubby, or not tubby,.....

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Scramble words (Excel97+)

    Ah, it finally dawns... - the "something rotten in the state of Denmark" was a bad egg!

  5. #5
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Yilgarn region of Toronto, Ontario
    Posts
    5,453
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Scramble words (Excel97+)

    >"something rotten in the state of Denmark" was a bad egg!
    So my code is an oeuvre d'oeuf?

  6. #6
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Scramble words (Excel97+)

    Un oeuf, already!

Posting Permissions

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