max text\number

[dwane101]

a would like to get excel to calculate max. letter or max. number if it is possible
form =

a = a
ab = b
abc = c
abcd = d
abcd0 = 0
abcd01 = 1
abcd012 = 2
abcd0123 = 3

is there a typical excel formula to do this ?

 

[J.E. McGimpsey]

Don't know about typical, but here's one way. It must be
array-entered (using CTRL-SHIFT-ENTER or CMD-RETURN):

=CHAR(MAX(CODE(MID(A1,ROWS(INDIRECT("1:"&LEN(A1))),1))))

 

[Mike]

=RIGHT(A1,1)

 

[Michael Bednarek]

a would like to get excel to calculate max. letter or max. number if it is possible
form =

a = a
ab = b
abc = c
abcd = d
abcd0 = 0
abcd01 = 1
abcd012 = 2
abcd0123 = 3

is there a typical excel formula to do this ?

=RIGHT(A1,1) should do it.