Results 1 to 5 of 5
  1. #1
    5 Star Lounger
    Join Date
    Mar 2004
    Posts
    924
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Using Find and Replace (200)

    I am trying to do a find and replace in Excel but don't think it is possible.

    What l am trying to do is to replace:

    LEOPARDGENHUMS

    to

    G:

    see screenshot.

  2. #2
    Super Moderator
    Join Date
    May 2002
    Location
    Canberra, Australian Capital Territory, Australia
    Posts
    5,054
    Thanks
    2
    Thanked 417 Times in 346 Posts

    Re: Using Find and Replace (200)

    Hi jj,

    Your screenshot explains why you're not getting a match! Hint: Look at your search string.

    Cheers
    Cheers,

    Paul Edstein
    [MS MVP - Word]

  3. #3
    5 Star Lounger
    Join Date
    Mar 2004
    Posts
    924
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Using Find and Replace (200)

    I will do that, thanks.

  4. #4
    Gold Lounger
    Join Date
    Feb 2004
    Location
    Cape Town, RSA
    Posts
    3,444
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Using Find and Replace (200)

    Besides the extra leading , you may also want to upgrade Excel 200 to Excel 2000 (or higher). I don't think I was around at that time, so I cannot vouch for the efficiency of the find and replace command in that version...

    Cheers <img src=/S/wink.gif border=0 alt=wink width=15 height=15>
    Regards,
    Rudi

  5. #5
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Using Find and Replace (200)

    The lack of a the dbl slashes () may be the reason why, in the thread starting at <post:=575,393>post 575,393</post:> , you could not get the code to find the files with the network names.

    Steve

Posting Permissions

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