We can test the last character with ISNUMBER()

=LEFT(A1,LEN(A1)-1) & IF(ISNUMBER(--RIGHT(A1,1)),"NUMBER","LETTER")

and copy down
--
Gary''s Student - gsnu200767


"doyree" wrote:

Hello

i have a question regards to using wild card in IF function

A
APPLE 1
APPLE A
APPLE 2
APPLE B

i wrote a formula like that would sort ablove like this
b2=APPLE NUMBER
b3=APPLE LETTER
b4=APPLE NUMBER
and etc.

thank you much!!