Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Find cell containing a letter
I have a column of numbers that were scanned in and OCR often makes mistakes
inserting a "S" instead of an "8" for example or an "O" instead of an "0". Any ideas on how I can find any cells that contain A-Z in a cell of numbers? I tried just sorting and picking up the mistakes at the bottom, however, that does not always work. If the list of telephone numbers 000-000-0000 contains a letter 603-5S5-0000 this does not sort to the bottom.. Thanks for the help! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Find column letter of the first unused cell | Excel Worksheet Functions | |||
Find Capital Letter | Excel Worksheet Functions | |||
FIND LETTER IN CELL (cond. form mult entries not wrking) | Excel Discussion (Misc queries) | |||
find column letter | Excel Discussion (Misc queries) | |||
How do I find a cell starting with a specific letter? | Excel Discussion (Misc queries) |