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?
|