Results 1 to 8 of 8

Remove substring with RegEx

Threaded View

  1. #1
    Forum Contributor
    Join Date
    07-11-2010
    Location
    Minneapolis, USA
    MS-Off Ver
    Excel 2016
    Posts
    308

    Remove substring with RegEx

    Hello, I have a problem that I think needs RegEx to solve and I am confounded by RegEx

    I have two Identical columns A & B were some of the cell values are in th form

    TextString - DifferentTextString [string]? e.g Baltimore Asthma Management - How strongly do you value your relationship with [Field-2]?

    In column A I need to remove the middle part - DifferentTextString and the ? leaving TextString [string] as the cell value e.g Baltimore Asthma Management [Field-2]

    And in column B I need only the middle part DifferentTextString e.g How strongly do you value your relationship with

    Thanks in advance for any help on this
    Attached Files Attached Files
    Last edited by capson; 02-09-2018 at 10:37 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Use More then one Regex to determine a a name
    By AbertBean in forum Excel General
    Replies: 10
    Last Post: 02-02-2018, 08:55 AM
  2. How to search substring against row and if duplicates found, remove them?
    By joshman10888 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-03-2016, 10:00 PM
  3. Macro to search cells for substring and replace contents of cell if substring is found
    By robbyvegas in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-31-2015, 06:40 AM
  4. 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
  5. 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
  6. Using regex in vba to remove emty xml tags - is it possible?
    By Laurentius77 in forum Excel General
    Replies: 0
    Last Post: 06-23-2012, 03:10 AM
  7. [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

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