+ Reply to Thread
Results 1 to 2 of 2

Extract Text Differences Between Two Cells

  1. #1
    Registered User
    Join Date
    05-27-2011
    Location
    Dallas, Texas
    MS-Off Ver
    Excel 2007
    Posts
    1

    Extract Text Differences Between Two Cells

    I have to compare rule changes for a software program. The data exported gives me the new rule and the old. I want to find the differences between the new rule from the old rule and have the differences populate the adjacent cell. The rules are not identifical. I have added an example to my inquiry.

    Utilizing the sample. The new rule is in Column A2 and the old rule in B2. Is there an equation I can use to extact the differences to cell C2. The answer would be "UYG,*STK,*WIREX,*BMFIX,* FBRUX,*HEPRU," I just don't want to visually examine all the different rules, just too many.

    Thank you.
    Attached Files Attached Files

  2. #2
    Registered User
    Join Date
    05-16-2011
    Location
    Toronto, ON
    MS-Off Ver
    Excel 2007
    Posts
    16

    Re: Extract Text Differences Between Two Cells

    Although I am not advanced, you will need a complicated macro or use text to column (use comma as separator) for both A2 and B2 (store in different sheets)

    Then do vlookup for each word in A2 with the B2 table. The restriction in this and macro (although doable) is checking backwards; whether B2 exists in A2

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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