Wildcard for ALPHA only
 

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?

--
Eva H. Linich
Business Applications

Wildcard for ALPHA only
 

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.

Wildcard for ALPHA only
 

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


"Eva at Work" wrote:

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?

--
Eva H. Linich
Business Applications

Wildcard for ALPHA only
 

The ISTEXT function worked!
Thanks.

I wanted to EXCLUDE anything that contained text of any type.
--
Eva H. Linich
Business Applications



"BigPig" wrote:

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.