Hi Tom,
Here is an easy way...please use code function like =CODE(A1), so you can
use MAX function.
--
Kind Regards
Colo
/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/
Colo of 'The Road of The Cell Masters' :)
URL:
http://www.interq.or.jp/sun/puremis/...astersLink.htm
/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/
"Tom" wrote in message
...
Hi
I have a column with alphanumeric data. The max function works only with
numeric values. How to calculate the max-value of alphanumeric values?
Tom