+ Reply to Thread
Results 1 to 4 of 4

formula for looking at a text string for a letter

  1. #1
    Registered User
    Join Date
    11-01-2012
    Location
    Madisonville, KY
    MS-Off Ver
    Excel 2010
    Posts
    47

    formula for looking at a text string for a letter

    I am needing a formula to look at another cell and if the last character in the cell is a letter, return one value, and if the last character is a number, return another value

    Example Cell B1 would look at A1 and if the last character in A1 is a letter is would give the result of "Yes", if the last character is a number it would give the result of "No"

    A B
    1 4391-1B Yes
    2 4391-2 No
    3 4390-2C Yes

  2. #2
    Forum Expert Tony Valko's Avatar
    Join Date
    12-31-2011
    Location
    Pittsburgh
    MS-Off Ver
    2002, 2007:2013
    Posts
    18,890

    Re: formula for looking at a text string for a letter

    Try this...

    =IF(COUNT(-RIGHT(A1)),"No","Yes")
    Biff
    Microsoft MVP Excel
    Keep It Simple Stupid

    Let's Go Pens. We Want The Cup.

  3. #3
    Registered User
    Join Date
    11-01-2012
    Location
    Madisonville, KY
    MS-Off Ver
    Excel 2010
    Posts
    47

    Re: formula for looking at a text string for a letter

    thanks, worked like a charm

  4. #4
    Forum Expert Tony Valko's Avatar
    Join Date
    12-31-2011
    Location
    Pittsburgh
    MS-Off Ver
    2002, 2007:2013
    Posts
    18,890

    Re: formula for looking at a text string for a letter

    You're welcome. 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)

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