Closed Thread
Results 1 to 7 of 7

VBA code required to Extract the content between 2 words/Phrases

  1. #1
    Forum Contributor
    Join Date
    09-20-2014
    Location
    India
    MS-Off Ver
    2013
    Posts
    275

    VBA code required to Extract the content between 2 words/Phrases

    Dear all,

    I have a string with some specific format. All strings carry "SEE" and "IN" in it.
    These strings are listed in column A, from A2 cell (More than 2000 values).

    The length of the each is string is not constant, it varies.

    I need a code to extract the content between words "SEE and "IN"

    String somewhat looks like below,
    To verify this, SEE XXXX XXXXXX IN database.
    I want to extract XXXX XXXXXX from all the strings of VARYING LENGTH.
    Plz help.

  2. #2
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    22,464

    Re: VBA code required to Extract the content between 2 words/Phrases

    Duplicate
    http://www.excelforum.com/excel-prog...iple-rows.html
    Welcome to the Forum, unfortunately:

    This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

    Thread Closed.

  3. #3
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    22,464

    Re: VBA code required to Extract the content between 2 words/Phrases

    stnkynts

    Your post does not comply with Rule 7 of our Forum RULES. Please do not ignore requests by Administrators, Moderators and senior forum members regarding forum rules.

    If you are unclear about the request or instruction then send a private message to them asking for clarification.

    All participants:
    Please do not post a reply in a thread where a moderator has requested an action that has not yet been complied with e.g Title change or Code tags...etc. Thanks.

  4. #4
    Forum Contributor
    Join Date
    09-20-2014
    Location
    India
    MS-Off Ver
    2013
    Posts
    275

    Re: VBA code required to Extract the content between 2 words/Phrases

    Hello stnkynts,
    It works for few strings (Some 20 rows) but gives an error after that.

    Could you please check it again.?

  5. #5
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    22,464

    Re: VBA code required to Extract the content between 2 words/Phrases

    mchilapur, stnkynts

    Don't ignore moderator's request, you are violating forum rule.

    This is the last warning.

  6. #6
    Forum Contributor
    Join Date
    09-20-2014
    Location
    India
    MS-Off Ver
    2013
    Posts
    275

    Re: VBA code required to Extract the content between 2 words/Phrases

    What is that i'm violating..? I gont through the rule, i didnt follow it.Please clarify.

  7. #7
    Forum Moderator vlady's Avatar
    Join Date
    09-22-2011
    Location
    Philippines - OLSHCO -Guimba-Nueva Ecija
    MS-Off Ver
    2021
    Posts
    4,361

    Re: VBA code required to Extract the content between 2 words/Phrases

    Continue discussion here:
    @ stnkynts your post has been moved also in the link below


    http://www.excelforum.com/excel-prog...iple-rows.html



    Thread Closed.
    Last edited by vlady; 01-13-2015 at 01:25 AM.
    I think people forget the word "THANK YOU!!!!" Do you still know it???

    There is a little star ( ADD REPUTATION ) below those person who helped you. Click it to say your "PRIVATE APPRECIATION TO THEIR EFFORT ON THEIR CONTRIBUTIONS "

    Regards,
    Vladimir

Closed Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Advanced Filter for specific words/phrases within cells
    By dsal24 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 12-18-2014, 06:33 PM
  2. Replies: 1
    Last Post: 09-05-2014, 08:40 AM
  3. [SOLVED] Can I find duplicate phrases (not just occurrences of single words)?
    By michigandrea in forum Excel Formulas & Functions
    Replies: 13
    Last Post: 04-17-2014, 09:06 AM
  4. Finding certain words and phrases in a cell
    By JakeMann in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 08-30-2013, 01:25 AM
  5. VBA code which should extract web content
    By Kiran Kurapati in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-24-2013, 06:00 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