+ Reply to Thread
Results 1 to 4 of 4

Extract Capital Words

  1. #1
    Registered User
    Join Date
    11-21-2011
    Location
    boston, ma
    MS-Off Ver
    Excel 2007
    Posts
    25

    Talking Extract Capital Words

    Hello,

    So some people on this forum have been extremely helpful and have saved me hours upon hours with this project, I just need one more adjustment.

    I need to extract capitalized words from a string. Previously, I requested to extract all capital words EXCLUDING:
    -The first word
    -One which follows a period if the cell has >1 sentence
    -Specific words

    Now, I take it back and want to keep the first word. Is there a simple adjustment to the following code to accomplish this? Thank you.

    Please Login or Register  to view this content.

    Example: Excluding words following a period, and the word "Fox":

    A1: The quick brown Fox Jumps over the lazy dog. It was Very Neat.

    ideal outcome: The Jumps Very Neat



    Also: How about if we want to extract all excluding only specific words, but including all others whether they start a sentence or not?


    Thanks!

  2. #2
    Forum Expert mrice's Avatar
    Join Date
    06-22-2004
    Location
    Surrey, England
    MS-Off Ver
    Excel 2013
    Posts
    4,967

    Re: Extract Capital Words - My code needs an adjustment

    Try

    Please Login or Register  to view this content.
    Martin

  3. #3
    Registered User
    Join Date
    11-21-2011
    Location
    boston, ma
    MS-Off Ver
    Excel 2007
    Posts
    25

    Re: Extract Capital Words - My code needs an adjustment

    Sorry, didn't quite do it.

    Example given:

    Excluding words following a period, and the word "Fox":

    A1: The quick brown Fox Jumps over the lazy dog. It was Very Neat.

    ideal outcome: The Jumps Very Neat

    This last code gives me: Jumps It Very Neat

  4. #4
    Forum Moderator Leith Ross's Avatar
    Join Date
    01-15-2005
    Location
    San Francisco, Ca
    MS-Off Ver
    2000, 2003, & 2010
    Posts
    23,259

    Re: Extract Capital Words - My code needs an adjustment

    Hello agf12555,

    This UDF macro will extract the data according to your rules.
    Please Login or Register  to view this content.
    Sincerely,
    Leith Ross

    Remember To Do the Following....

    1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.
    2. Thank those who have helped you by clicking the Star below the post.
    3. Please mark your post [SOLVED] if it has been answered satisfactorily.


    Old Scottish Proverb...
    Luathaid gu deanamh maille! (Rushing causes delays!)

+ 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