How do I select the last alphanumric word in an excel column with.
 

Any insight would be greatly appreciated.

How do I select the last alphanumric word in an excel column with.
 

Try this:

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

Will return the last TEXT entry in column A.

Biff

"Puzzled Excel User" <Puzzled Excel wrote in
message ...
Any insight would be greatly appreciated.

How do I select the last alphanumric word in an excel column with.
 

=LOOKUP(2,1/(A1:A200<""),A1:A200)

will find number or text

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Biff" wrote in message
...
Try this:

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

Will return the last TEXT entry in column A.

Biff

"Puzzled Excel User" <Puzzled Excel wrote
in
message ...
Any insight would be greatly appreciated.