+ Reply to Thread
Results 1 to 6 of 6

Macro to search a string ending with vowel "AEIOUY"

  1. #1
    Registered User
    Join Date
    02-17-2013
    Location
    uae
    MS-Off Ver
    Excel 2003
    Posts
    9

    Macro to search a string ending with vowel "AEIOUY"

    Hi,
    I need some help ,could someone help me with a macro.
    In Column A i have a long list of alphanumeric words , some of them end with a vowel "aeiouy". I want a macro that will go thru the list in A, and check if word in a cell end with a vowel, then put it in B column, so that in B i will have all the words ending with a "AEIOUY".

    Thank's in advance.

  2. #2
    Forum Expert
    Join Date
    11-24-2013
    Location
    Paris, France
    MS-Off Ver
    Excel 2003 / 2010
    Posts
    9,831

    Re: Macro to search a string ending with vowel "AEIOUY"


    Hi,

    read VBA help of Right function ! And don't forget, Macro recorder is a friend !

  3. #3
    Valued Forum Contributor
    Join Date
    12-02-2012
    Location
    Melbourne, VIC
    MS-Off Ver
    Excel 2016
    Posts
    750

    Post Re: Macro to search a string ending with vowel "AEIOUY"

    try this:
    Please Login or Register  to view this content.
    Last edited by jewelsharma; 04-02-2014 at 04:35 AM. Reason: typo

  4. #4
    Valued Forum Contributor
    Join Date
    07-04-2012
    Location
    Cape Town, RSA
    MS-Off Ver
    Office 365 ProPlus
    Posts
    1,050

    Re: Macro to search a string ending with vowel "AEIOUY"

    You don't really need a macro for that.
    In cell B1, type this formula:
    =IF(OR(RIGHT(A1,1)="A",RIGHT(A1,1)="E",RIGHT(A1,1)="I",RIGHT(A1,1)="O",RIGHT(A1,1)="U"),A1,"")
    then autofill down.
    Regards,
    Rudi

  5. #5
    Forum Expert XOR LX's Avatar
    Join Date
    04-18-2013
    Location
    Turin, Italy
    MS-Off Ver
    Office 365
    Posts
    7,742

    Re: Macro to search a string ending with vowel "AEIOUY"

    If you're going down the formula route then also:

    =REPT(A1,OR(RIGHT(A1)={"a","e","i","o","u","y"}))

    Regards
    Click * below if this answer helped

    Advanced Excel Techniques: http://excelxor.com/

  6. #6
    Registered User
    Join Date
    02-17-2013
    Location
    uae
    MS-Off Ver
    Excel 2003
    Posts
    9

    Re: Macro to search a string ending with vowel "AEIOUY"

    Thanks , i appreciate all the help and quick response.

+ 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. 7 nested IF statements with a SEARCH added IF(ISNUMBER(SEARCH({"INSUR","AP REFUND"}
    By michaelproctor001 in forum Excel Formulas & Functions
    Replies: 15
    Last Post: 12-10-2013, 02:13 PM
  2. [SOLVED] macro to search for "NO" in a cell and copy all but "NO" to a different column! plz help
    By fredderf81 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-26-2013, 03:19 PM
  3. [SOLVED] search for a "part number" within a string and return its cell position or contents of cel
    By benakil in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 03-24-2013, 06:37 AM
  4. [SOLVED] Search numbers in a text string, find largest "value" return a value
    By OilGasKing in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 02-27-2013, 09:01 PM
  5. Developing a "Search" or "Find" Macro/ VBA Program
    By SamBevis in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-27-2013, 09:44 PM

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