View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
fgwiii[_2_] fgwiii[_2_] is offline
external usenet poster
 
Posts: 36
Default 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