+ Reply to Thread
Results 1 to 4 of 4

VBA or Function to delete Any string on multiples Range that Match range reference

  1. #1
    Registered User
    Join Date
    10-14-2017
    Location
    Miami, Florida
    MS-Off Ver
    2016
    Posts
    78

    VBA or Function to delete Any string on multiples Range that Match range reference

    Hi,

    I'm looking for a formula VBA or UDF to delete/Extract String from multiples ranges if Match Range reference (i haven't see one)

    Example:
    Range Reference D2:N2 Have a strings--------------------------> 01,02,03,04,05,06,07,08,09,10,11

    Range 2 D5:N5 Have Strings ------------------------------------->25,31,40,27,01,12,03,15,06,14,18
    As Output need to get Range2 String without the matched ---->25-31-40-27-12-15-14-18

    Range 3 D9:N9 Have Strings ------------------------------------->04-18-30-08-29-13-28-15-07-22-02
    As Output need to get Range3 String without the matched ---->18-30-29-13-28-15-22

    Range 4 D12:N12 Have Strings ------------------------------------->32-33-34-26-05-12-08-06-29-09-16
    As Output need to get Range4 String without the matched ---->32-33-34-26-12-29-16

    Range 5 D15:N15 Have Strings ------------------------------------->41-02-17-23-10-01-11-15-06-20-04
    As Output need to get Range5 String without the matched ---->41-17-23-15-20

    In advance Thank you very much!!
    Attached Files Attached Files
    Last edited by AndyJr; 08-17-2019 at 10:55 PM. Reason: forgot to thanks, forgot to change ranges ID

  2. #2
    Forum Guru sktneer's Avatar
    Join Date
    04-30-2011
    Location
    Kanpur, India
    MS-Off Ver
    Office 365
    Posts
    9,640

    Re: VBA or Function to delete Any string on multiples Range that Match range reference

    You may try this Array Formula which requires confirmation with Ctrl+Shift+Enter instead of Enter alone.

    In D6
    Please Login or Register  to view this content.
    Confirm with Ctrl+Shift+Enter and then copy across.

    You may copy the same formula to other ranges.
    Regards
    sktneer


    Treat people the way you want to be treated. Talk to people the way you want to be talked to.
    Respect is earned NOT given.

  3. #3
    Registered User
    Join Date
    10-14-2017
    Location
    Miami, Florida
    MS-Off Ver
    2016
    Posts
    78

    Re: VBA or Function to delete Any string on multiples Range that Match range reference

    Hi sktneer

    It works Perfect!!


    Thank you!!!

  4. #4
    Forum Guru sktneer's Avatar
    Join Date
    04-30-2011
    Location
    Kanpur, India
    MS-Off Ver
    Office 365
    Posts
    9,640

    Re: VBA or Function to delete Any string on multiples Range that Match range reference

    You're welcome Andy! Glad it worked as desired.
    Thanks for the feedback!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 3
    Last Post: 08-14-2017, 06:26 AM
  2. Replies: 3
    Last Post: 01-22-2015, 06:21 PM
  3. [SOLVED] Modify VBA Code Search Hilight from 1 range to multiples range?
    By david gonzalez in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-26-2014, 08:04 PM
  4. [SOLVED] reference date time range, return the value into all cell that match datetime range
    By Jarvco13 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 09-22-2013, 10:39 PM
  5. Replies: 2
    Last Post: 12-12-2012, 04:19 AM
  6. Replies: 9
    Last Post: 10-02-2011, 08:37 PM
  7. How to get reference to a range as string?
    By jtan@alum.mit.edu in forum Excel General
    Replies: 1
    Last Post: 01-15-2005, 07:06 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