+ Reply to Thread
Results 1 to 3 of 3

Finding if a value appears after 3rd letter in a string

  1. 02-25-2014, 10:30 AM #1
    Dan27
    Dan27 is offline
    Forum Contributor
    Join Date
    02-14-2008
    Location
    Manchester, England
    MS-Off Ver
    2007
    Posts
    110

    Finding if a value appears after 3rd letter in a string

    Hello

    I have columns of data that are maded up of markers. Such as XYXNXXNXNXNX.

    I'd like a formula that looks at the 3rd character onwards and if a 'Y' appears then It returns the word "yes" else "no"

    Can anyone help?

    Thanks
    Reply With QuoteRegister To Reply
  2. 02-25-2014, 10:32 AM #2
    FDibbins
    FDibbins is offline
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,944

    Re: Finding if a value appears after 3rd letter in a string

    Maybe this...
    =if(left(a1,4)="Y","Yes","No")
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford
    Reply With QuoteRegister To Reply
  3. 02-25-2014, 10:35 AM #3
    daddylonglegs
    daddylonglegs is offline
    Forum Expert daddylonglegs's Avatar
    Join Date
    01-14-2006
    Location
    England
    MS-Off Ver
    2016
    Posts
    14,675

    Re: Finding if a value appears after 3rd letter in a string

    Try using COUNTIF like this

    =IF(COUNTIF(A2,"*??Y*"),"Yes","No")

    where A2 contains your data
    Audere est facere
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Getting info from a cell after the last letter appears...
    By swade730 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-13-2014, 10:50 PM
  2. Finding whether any number appears before one of a selection of keywords in a string
    By brentcahill in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-22-2013, 01:35 AM
  3. find how many times a word appears in a string at certain positions within the string
    By jordan2322 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 02-05-2013, 12:05 AM
  4. [SOLVED] Finding an uppercase letter in a string parameter of a UDF
    By dredwolf in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 11-22-2012, 11:43 PM
  5. [SOLVED] HELP! Need to delete row ONLY if the letter N appears in BOTH column G and H
    By PLEASEHELPASAP in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 08-02-2012, 07:29 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1