Text or number

[manisai]

Hi,

Can someone help me on this

I need a function.

cell a1 contain a text and number if mid of a1,1,1 = text then c else w.

e.g

54890051 = c
VC040400= w

Thanks in advance
Manisai

[:) Sixthsense :)]

In A1 Cell

54890051


In B1 Cell

=IF(A1="","",IF(ISERR(LEFT(A1)+0),"w","c"))

Drag it down..