Results 1 to 3 of 3

Macro to search cells for substring and replace contents of cell if substring is found

Threaded View

robbyvegas Macro to search cells for... 10-28-2015, 05:19 AM
JOHN H. DAVIS Re: Macro to search cells for... 10-28-2015, 07:12 AM
robbyvegas Re: Macro to search cells for... 10-31-2015, 06:40 AM
  1. #1
    Registered User
    Join Date
    02-11-2010
    Location
    Maryland, USA
    MS-Off Ver
    Excel 2007
    Posts
    83

    Macro to search cells for substring and replace contents of cell if substring is found

    Hey all,

    I'm working on a project where I need to search the contents of a couple different columns of data (columns K & L in the "3D Printing Patents" tab of the attached workbook) for substrings contained on a separate worksheet (COL A of the "Replace List" worksheet). When a substring is found in a cell in columns K or L, I'd like to replace the entire contents of that cell with the string that correlates to the substring found (COL B in the "Replace List" worksheet.)

    I need the operation to NOT be case sensitive. I have a macro in the attached worksheet that works to replace with a particular string that is listed there in the macro, but I'm admittedly pretty inexperienced with VBA and don't know how to modify it to do what I need it to do. Can you guys/gals help?

    Thanks,

    Rob
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. macro to copy cell contents then remove substring of contents in new cell - Help
    By three_jeeps in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-25-2015, 01:19 AM
  2. Search substring within range, report the substring found
    By Brooke1578 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 12-20-2012, 03:56 PM
  3. Replies: 2
    Last Post: 06-29-2012, 07:02 AM
  4. Find and Replace Substring
    By ncalenti in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-14-2012, 06:54 PM
  5. [SOLVED] Extract Substring, then Ignore that Substring, while collecting data from Other substrings
    By Sameki121 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 04-17-2012, 05:21 PM
  6. Splitting a row into two when a certain substring is found
    By lifeseeker1019 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-17-2011, 11:32 PM
  7. Find and Replace the character in a substring.
    By saikumar in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-14-2009, 04:44 AM

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1