+ Reply to Thread
Results 1 to 2 of 2

Recognize if the first character in a cell is a letter or a number

  1. #1
    Registered User
    Join Date
    01-10-2013
    Location
    Stockholm,Sweden
    MS-Off Ver
    Excel 2003
    Posts
    1

    Recognize if the first character in a cell is a letter or a number

    Hi, I'm using Excel 2003. I think that my question applies to other versions also.
    Since I'm from Sweden I use the swedish version of Excel, but I will try to explain it in English.

    I would like an Excel-sheet to work like this:

    I'm trying to use the IF formula. ( In Sweden it's called OM formula)

    In one cell I'm planning to write an IF-expression.

    I would like it to depend on if another cell has a string in it that
    starts with any letter (A-Z) or with any number (0-9)

    I'm thinking of something like this:

    If I write the expression in cell E15 for example,

    then if cell A3 starts with a letter the value in E15 will be AAA for example and if cell A3 starts with a number then the value will be 999 for example

    I've have written some simple IF-expressions but I don't know how to write this.

    Thank's in advance from Sweden!

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16/365
    Posts
    52,118

    Re: Recognize if the first character in a cell is a letter or a number

    hi b00jko and welcome to teh forum.

    try this...
    =IF(ISNUMBER(VALUE(LEFT(A3,1))),"Number","Text")

    change "Number" and "text" to whatever you need
    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 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