Wildcard for ALPHA only

E

Eva at Work

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?
 
B

BigPig

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.
 
R

Ron Coderre

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
 
E

Eva at Work

The ISTEXT function worked!
Thanks.

I wanted to EXCLUDE anything that contained text of any type.
 
Top