Results 1 to 3 of 3
  1. #1
    New Lounger
    Join Date
    Aug 2005
    Posts
    1
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Multiple Find & Replace (XP 2003)

    I receive an auto generated weekly report (in excel) that contains the names of web pages in computereaze. I need to translate these names into a recognizable format of named pages. There are 100-150 items in this list, how can I do a multiple find and replace that looks for a value from one list and replaces it with the value from the corresponding row (the report will not display the same names in the same order) Thoughts?

  2. #2
    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: Multiple Find & Replace (XP 2003)

    Could using a Vlookup work in some way?

    I can't be more specific without a few more details of your setup...

    Steve

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

    Re: Multiple Find & Replace (XP 2003)

    Welcome to Woody's Lounge!

    To expand on Steve's reply, see the attached workbook. Sheet2 contains a lookup table, and Sheet1 contains formulas in column B that look up the description of the "computerese" names in column A. Column A could be hidden, or you could copy column B and use Paste Special > Values to paste it over column A.

Posting Permissions

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