+ Reply to Thread
Results 1 to 2 of 2

How to determine if last char in a text cell is a number or a letter

  1. #1
    Registered User
    Join Date
    04-05-2010
    Location
    Boston, MA
    MS-Off Ver
    Excel 2007
    Posts
    1

    Exclamation How to determine if last char in a text cell is a number or a letter

    Hi,

    I need to return one value if the very last character in a cell containing text is a number (ie the characters 0 thru 9), otherwise return a different value.

    I've tried all sorts of strong parsing methods, but almost always get an error.

    Could someone please assist ?

    Thanks so much !!

    Steve C.

  2. #2
    Registered User
    Join Date
    03-24-2010
    Location
    Pune, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    36

    Lightbulb Re: How to determine if last char in a text cell is a number or a letter

    Hi,

    You can try this formula:

    Please Login or Register  to view this content.
    This example considers that your A1 cell contains the text from which you wish to check the last char of the cell is number or not. Please modify this formula according to your need.
    Cheerz,
    ~Ne@l

    *********************************************************************
    Save a tree. Please think before you print this post and/or attachments.

+ 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