Try this:

=LOOKUP(REPT("Z",255),A:A)

Assumes there are no formula blanks (empty TEXT strings) within the range.

--
Biff
Microsoft Excel MVP


"BAKERSMAN" wrote in message
...
How do I look up the last alpha numeric value in a column? I can get the
last
numerical value just not the alpha numerical one. Can someone help?