A number or a letter?

**koltregaskes** · 10-27-2011, 10:21 AM

I have a large list of "sites" that are basically numbers ranging from 1 to 99999. Some have letters at the end and some don't. Is there an Excel formula that can say whether the last letter of each "site" is a letter or a number?

For example, I like Excel to tell me this is a letter: 77734C and that this is a number 3546.

**koltregaskes** · 10-27-2011, 10:23 AM

The reason I need to know is that the letter refers to an "option" and I would like the "option" extracted from the "site" number so I can put it into another column on the report.

**TMS** · 10-27-2011, 10:23 AM

=RIGHT(cell address,1)

Regards

**Fotis1991** · 10-27-2011, 10:36 AM

Hi

I attach you my proposal.

Regards

**TMS** · 10-27-2011, 11:08 AM

Try:

=IF(ISNUMBER(--RIGHT(A2,1)),"Number","Letter")

Regards

**koltregaskes** · 10-28-2011, 06:13 AM

TMShucks - thanks for the second suggestion, that was the one. The first was obviously too basic. :-)

Fotis1991 - sadly I cannot open that attachment up from my work machine.