for A B C D use array-entered (i.e. insert the formula with CTRL+SHIFT
+ENTER):

=CHAR(MAX(CODE(A1:D1)))

for A B 0 1 use:

=MAX(A1:D1)




On 17 Lis, 09:26, bengles wrote:
would someone be able to help me out in finding the maximum value in a row or
column containing letters and numbers. letters in this case would be a lower
value compare to the numbers.

for example in a row:

A B C D <- returns the value D as max
A B 0 1 <- returns the value 1 as max

thanks