please i need function for exceal mac

[mgm90210M]

not a macro that
do the swich statement
and not if function because it is long

if a1=a so write 1
if a1=b so write 2
if a1=c so write 3
if a1=d so write 4
if a1=e so write 5
if a1=f so write 6
if a1=g so write 7




thanks

 

[RoryA]

=MATCH(A1,{"a","b","c","d","e","f","g"},0)
for example.

 

[Special-K99]

=CODE(A1)-96

may be shorter though I'd go with RoryA's solution since it checks for specific characters

 

[par60056]

how about:
=CODE(A1)-CODE("a")+1