Wildcard for ALPHA only

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Lots of posts having to do with wildcards - but I haven't found the answer to
my question.

I have a column of ZIP CODES - but I want to filter OUT any zips that
include alpha characters. Numbers are fine - but I don't want anything that
includes alpha characters. Seems simple, so why can't I figure that out?

Suggestions?
 
Hi Eva at Work,

You could try:
=IF(ISTEXT(A1)=TRUE,"",A1)

Where A1 holds zipcodes.

The formula evaluates the cell to see if there is any text in it, ie abcde,
if so it returns nothing, otherwise it returns the value of the cell.
 
What are possible patterns for you zip codes?
Might they include hypens (01234-5678)?
What are some examples that you would want excluded?

***********
Regards,
Ron

XL2002, WinXP-Pro
 
The ISTEXT function worked!
Thanks.

I wanted to EXCLUDE anything that contained text of any type.
 
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

Wildcards in If statements 4
"Find" a wildcard as a place marker and "replace" with original va 1
Extract alpha from a cell 1
Alpha with numeric and numeric only numbers in a column 6
wildcard for numbers only 4
Alpha sorting (with a twist...?) 3
Use of Wildcard characters with replace 2
How to avoid '*' being used as wildcard in SUMIF? 6

Back
Top