View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ted Metro Ted Metro is offline
external usenet poster
 
Posts: 29
Default Search list for non-alpha characters

I have a list of companies starting in A1 --

Amazon.com
Best Buy
Yahoo!
Wal-Mart
Target
Kohl's
SPSS

I would like a formula I can copy down that would display a true/false
whether or not there is a character in the company name that is something
other than a letter.

The character code ranges are 65-90 and 97-122, so if there is any character
in the name that falls outside that code range I would get a true, otherwise
a false.

In the list above the false values would be SPSS, Best Buy and Target,
although I suppose I'll have to remove the spaces out of the name first to
make this work.

Any ideas how to search a string for a range of character codes?