If Statement for text / numbers

[brumby]

Hiya all,

Is it possible to have an if type statement to look at the first character of a cell to see if it starts with a number or a text letter?

something like....

=IF(A5="CELL CONTENTS START WITH A NUMBER","A","B")

Is this possible?


Many Thanks

 

[Joe4]

Here is one way:

=IF(AND(CODE(LEFT(A5,1))>=48,CODE(LEFT(A5,1))<=57),"It is a number","It is not a number")

 

[T. Valko]

something like....

=IF(A5="CELL CONTENTS START WITH A NUMBER","A","B")

One way...

=IF(COUNT(-LEFT(A5)),"A","B")

 

[Joe4]

=IF(COUNT(-LEFT(A5)),"A","B")

Clever!
Taking advantage of the fact that COUNT only counts numbers and using a negative to coerce the string of a number to be read as a number...

 

[brumby]

thanks guys, superb!!!!

 

[brumby]

sorry 1 more request,

If true I want to return a ", yes simple return the character ", I thought i would do that by entering """, but it doesnt work?

 

[Joe4]

Do you mean that if TRUE, you want to simply return that one character?
LEFT(A5,1)
would do that.

 

[brumby]

not quite, if true I want to return the " symbol

 

[Joe4]

You can either use:
""""
or
CHAR(34)

 

[T. Valko]

not quite, if true I want to return the " symbol

So what do you want if FALSE?

This will return " if TRUE and a blank "" if FALSE:

=IF(COUNT(-LEFT(A5)),"""","")