Results 1 to 5 of 5

Return TRUE if 1st 2 characters in text are alpha values

Threaded View

  1. #1
    Registered User
    Join Date
    05-21-2013
    Location
    SLC
    MS-Off Ver
    Excel 2007
    Posts
    7

    Return TRUE if 1st 2 characters in text are alpha values

    Using Excel 2007.

    In Column A, (formatted as text), I have various text values, some beginning with 2 alpha values followed by several numeric values (i.e. AB123456), others contain just pure numbers (012345). In column B, i would like to create an IF statement that will return a TRUE if the 1st 2 characters in the cell in A are alpha values.

    So, if my Column A looked like below, Column B would return:

    A B
    AB123456 TRUE
    0987654 FALSE
    ZY987654 TRUE
    123789 FALSE
    Last edited by BasinCruiser; 05-22-2013 at 09:31 AM.

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