| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I count wildcard text meeting certain criteria in EXCEL? | Excel Worksheet Functions | |||
| how to use * wildcard in a sum(if((cond),range)) array formula | Excel Worksheet Functions | |||
| Wildcard Problem.... | Excel Discussion (Misc queries) | |||
| Question regarding wildcard in multi-criteria IF formula | Excel Worksheet Functions | |||
| Sumif using wildcard | Excel Worksheet Functions | |||
Linear Mode
