Results 1 to 3 of 3

Find and Replace

Threaded View

littlefoot Find and Replace 05-12-2017, 07:27 AM
Special-K Re: Find and Replace 05-12-2017, 08:20 AM
Jacc Re: Find and Replace 05-12-2017, 04:44 PM
  1. 05-12-2017, 04:44 PM #3
    Jacc is offline
    Forum Expert
    Join Date
    09-01-2012
    Location
    Norway
    MS-Off Ver
    Office 365
    Posts
    2,885

    Re: Find and Replace

    You can create a copy of the table, apply this very basic INDEX MATCH formula and then copy and paste the new values over the old table. Use copy and "paste as value".
    Attached Files Attached Files
    <----- If you were helped by my posts you can say "Thank you" by clicking the star symbol down to the left

    If the problem is solved, finish of the thread by clicking SOLVED under Thread Tools
    I don't wish to leave you with no answer, yet I sometimes miss posts. If you feel I forgot you, remind me with a PM or just bump the thread.
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Using find replace to first find two double quotes and replace with a single double quote
    By welchs101 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 06-17-2015, 10:13 AM
  2. [SOLVED] Find and replace where contents a formula so can't be seen by Find and replace.
    By markDuffy in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-26-2015, 02:24 PM
  3. More Versatile Find and Replace - Find and Replace Within a Cell
    By KristofferA in forum Excel General
    Replies: 16
    Last Post: 12-02-2014, 03:38 PM
  4. Need a macro to find and replace words in word using excel column 1(find) column (replace)
    By ramradha6 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-25-2014, 06:08 AM
  5. [SOLVED] find and replace to not replace characters found as wildcards
    By sabutler4 in forum Excel General
    Replies: 4
    Last Post: 07-03-2013, 06:48 PM
  6. find in excel replace in word: find/replace text in text boxes and headers
    By dean.rogers in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-10-2012, 12:40 PM
  7. [SOLVED] find and replace - replace data in rows to separated by commas
    By msdker in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-14-2006, 08:10 PM

Bookmarks

Posting Permissions

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1