If formula

[subrosumon]

Hi Bro,
I want to help from you to implement if formula
e.g.
1. 7060006-56to72USD-Septo Jun16
2. Cost Clg. Reconciliation

I want to get for sl. 1. when first digit will numeric it will say "INVOICE"
sl. 2. when it says Alphabetic it will say "OTHER" to use if formula,
Can you please help me?

Thanks in advance.

 

[Vbagreenhorn1]

try this:

=IF(ISNUMBER(LEFT(A1)*1),"INVOICE","OTHER")

 

[subrosumon]

Many Thanks, excellent bro