Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Can you ID a cell that has both Alpha AND Numeric characters?
Hello,
I have a data field (for a land parcel spreadsheet) that is named Tract Number. The field is formatted for text, and a sample value would be this: 7-5-047-088. But there are some cells that contain a combination of numbers AND text such as 7-5-047-E14, with the letter E in the last group of numbers. Is there a way to quickly flag ANY cells that contain Alpha characters? I've already tried to use the ISTEXT function, and it doesn't differentiate between the two types I've already mentioned. Thanks in advance for your replies. Phil. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Parsing a alpha character out of a cell | Excel Worksheet Functions | |||
Search string for alpha or numeric | Excel Worksheet Functions | |||
The colums changed from alpha to numeric how do you make it alpha | Excel Discussion (Misc queries) | |||
Alpha & Numeric Counts in Excel | Excel Discussion (Misc queries) | |||
Count unique alpha numeric "characters" in a common cell | Excel Worksheet Functions |