You can handle both upper and lower cases in one formula...

B1: =CODE(UPPER(A1))-64

Rick


"Max" wrote in message
...
Just another angle to your post ...

With single capital* letters (A,B,C ... ) assumed in A1 down
try this tinker in B1: =CODE(A1)-64
Copy down

*it's lower case single letters in A1 down
use in B1, copied down: =CODE(A1)-96
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Batshon" wrote:
hi all,
Am trying to convert A, b, C (text) into 1,2,3
Can anybody help me in putting the right formula?
Cheers..