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

[b00kjo]

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!

[FDibbins]

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