Convert number into letter, it is possible?

1	=p
2	=b
0	=t

hi guy simple, what formula do I use to convert 1 = p , 2 = b , 0 = t

thanks

Try this

=CHOOSE(H2+1,"t","b","p")

wow nice thanks!

ooops, i think you suppose to put

=CHOOSE(A1+1,"t","p","b")

I think i found it

=LOOKUP(A1,{0,1,2},{"t","p","b"})

Originally Posted by Exxcel Noob

but what if i want to change it to

A1: 1 = p
A2: 2 = b
A3: 3 = t

Then you use

=CHOOSE(A1,"p","b","t")

Originally Posted by Bob Phillips

Then you use

=CHOOSE(A1,"p","b","t")

PERFECT !

WOW THANKS Bob Phillips