| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Ranking Alpha Characters | Excel Discussion (Misc queries) | |||
| A validation rule on Alpha and Numeric characters | Excel Worksheet Functions | |||
| Can you ID a cell that has both Alpha AND Numeric characters? | Excel Worksheet Functions | |||
| Alpha characters problem? | Excel Worksheet Functions | |||
| Check for Alpha characters | Excel Discussion (Misc queries) | |||
Threaded Mode
