If you are just talking about the first letter in the text then
=CHAR(MAX(CODE(LEFT(G1:G4,1))))

array entered (Ctrl + Shift + Enter) will return the *Max* character

I don't know if this is what you want

Regards

"tonywig" wrote in
message ...

I want to find the highest value in a column of text.
MAX (it appears) only deals with numeric values.

MUST be possible surely since I can sort on that column OK.


Any help greatfully received.


--
tonywig


------------------------------------------------------------------------
tonywig's Profile:
http://www.excelforum.com/member.php...o&userid=18985
View this thread: http://www.excelforum.com/showthread...hreadid=379061