Find cell containing a letter

J

Jon Hebert

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!
 
L

Luke M

If the format your dealing with is all like that:
000-000-0000

Perhaps this will do the trick:

=IF(ISNUMBER(VALUE(SUBSTITUTE(A2,"-",""))),"","Letter present")
 
J

Jon Hebert

I placed 000-00A-0000 in A2 and typed your formula in B2
I got "False" as a result.

I then ran your formula on 000-000-0000 and I got Letter present..

What do you think?

Thank you!
 
L

Luke M

Did you copy formula exaclty? When I copy your examples into A2 on my sheet,
it works. Perhaps Stan's workbook can shed some light?
 
J

Jon Hebert

Thank you for taking the time to check this. Luke M's sheet showed me my
mistake!

I appreciate your time!
Jon
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Find the first letter in a cell 5
Sorting data with the letter 'E' included 3
How do I add a 0 and 2 dashes to a truncated soc. sec.# in a cell 10
replace numbers in excel 3
Array Function to do a Sum of VLookUps that translate a letter gra 3
return a formula instead of a value of a cell 4
For Joey2004 et al. From OP: Re Appending Question 3
Sorting by rows with differing numbers of cell entries 3

Top