View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
JE McGimpsey
 
Posts: n/a
Default how do I find a max TEXT value?

One way (array-entered: CTRL-SHIFT-ENTER or CMD-RETURN):

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

Adjust the range as required.

In article ,
Phoebe wrote:

I am trying to use the max function but on a series of text values ie. a, f,
h, k - to return K as max value