Results 1 to 5 of 5
  1. #1
    3 Star Lounger
    Join Date
    Jan 2004
    Location
    London, Middlesex, England
    Posts
    268
    Thanks
    0
    Thanked 0 Times in 0 Posts

    XL: True Global Search and Replace

    Hello,

    The screenshot shows XL's Replace dialogue box. When I click "Replace all"

  2. #2
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: XL: True Global Search and Replace

    Click the Options button.
    Alternatively, download my flexfind from my website, which can also S&R in chart titles and many other things the normal S&R doesn't.
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

  3. #3
    3 Star Lounger
    Join Date
    Jan 2004
    Location
    London, Middlesex, England
    Posts
    268
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: XL: True Global Search and Replace

    Fabulous.

    Bob.

  4. #4
    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: XL: True Global Search and Replace

    You can also select all the sheets (using ctrl or shift while selectinig) you want to find/replace in before running the find/replace.

    Steve

  5. #5
    Star Lounger
    Join Date
    Mar 2003
    Location
    Sydney, New South Wales, Australia
    Posts
    54
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: XL: True Global Search and Replace

    Navigator Utilities also has an advanced Find/Replace which works well in earlier versions of Excel as well as XP etc. AS well as working accross all sheets in a workbook, you can also work accross all workbooks that are currently open.

    There is also lots of help with Names and Links.

Posting Permissions

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