Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Looking for alpha characters in a field
Good Morning,
I have a listing in Excel where I have a field that should only contain dates using number characters. The issue is that if part of the date is missing or unknown, they will be keyed using either "M" or "U" for the missing or unknown values. What I am looking for is a solution for identifying records that contain alpha characters. Thank you for your help! Fred |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Looking for alpha characters in a field
Hi,
I'm not sure I understand the format of this field but the simplest test would be =ISTEXT(A1) This would return true if A1 contained any Alpha characters Mike "fgwiii" wrote: Good Morning, I have a listing in Excel where I have a field that should only contain dates using number characters. The issue is that if part of the date is missing or unknown, they will be keyed using either "M" or "U" for the missing or unknown values. What I am looking for is a solution for identifying records that contain alpha characters. Thank you for your help! Fred |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Find alpha all characters | Excel Discussion (Misc queries) | |||
HOW DO YOU COUNT ALPHA CHARACTERS IN AN ALPHANUMERIC FIELD | Excel Discussion (Misc queries) | |||
Ranking Alpha Characters | Excel Discussion (Misc queries) | |||
Alpha characters problem? | Excel Worksheet Functions | |||
Merge an alpha field and a numeric field | Excel Discussion (Misc queries) |