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

  • Thread starter Thread starter Guest
  • Start date Start date
Try this:

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

Will return the last TEXT entry in column A.

Biff
 
=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)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Fill last row down for large selection? 1
Help needed with a formula, please. 2
Excel Average dates help 0
IF cell A1 contains "X", enter "X" in cell B1, if not enter "Y" HE 2
Average more than 30 numeric arguments 15
How do I get Excel to automatically calculate the value of a hyper 2
EXCEL - IF(IFERROR(VLOOKUP question 0
Last "non-blank" value in a Row... 2

Back
Top