"FIND" alpha characters in one specific column

I have a report that has 11 columns with various information in each column: i.e. customer name, customer account #, invoice #, invoice date, original inv amt

My question is this: Is there a way to search one specific column that should have numeric characters only for any alpha characters? They are not going to be specific alpha charaters - it can be anything from just "A" to "COR","CM", "DP"....or just a key error of an alpha character.

Here's an example:

45-732668 CM
PYMNT000000020470
60-029752DP
4042-721655 DP
4042-746882.1
CM ACH # 2240315
09-755934DP
46-661931DP
6076-677519WOFF
PYMNT33429MOVE
PYMNT32384MOVE
45-740471OP
50653944-REVCT
46-777981
46-777983
46-781947

What are all of the rules?
Are negative numbers allowed? The numbers are really just labels. Invoice numbers - so they aren't going to be positive or negative numbers. They are formatted as "GENERAL."
Do you want to simply check if any cells contain non-numeric characters?
Do you want to flag them? Delete them? I would like to flag them so I can sort and move them to another worksheet within the spreadsheet.

yes, thank you! I will try it.

=ISNUMBER(--A1)*(A1>0) is giving me "0" on the entire column

=IF(ISERROR(--SUBSTITUTE(A1,"-","")),"TRUE","FALSE") is giving me "false" on cells with no alpha characters as well as true.

One of the problems is that I cannot specify the column as a numeric column because there are leading zeros. These numbers are labels that should consist of numeric characters only - but some of them had alpha characters tacked on at the end to specifiy an error, or a debit memo...the list is over 10,500 rows, so it makes it tedious to scroll through the spreadsheet manually trying to find the alpha charaters.

Any other suggestions????? hope-hope

But =IF(ISERROR(--SUBSTITUTE(A1,"-","")),"TRUE","FALSE") is still giving me incorrect "True" and "False"

It seems inconsistent....

Inv#
07-699161.1 FALSE
50-740574OP FALSE
07-710791.1 FALSE
DMACH1190130733 FALSE
PYMNT32188MOVE4 FALSE
6076-662572WOFF FALSE
PYMNT32107MOVE FALSE
46-686088DP FALSE
46-752320OP FALSE
46-661931DP FALSE
35-548425CM FALSE
6081-727938DP FALSE
45-749341OP FALSE
PYMNT33429MOVE FALSE
9122-740292DP FALSE
1040-727911DP FALSE
9098-1033722 FALSE
PYMNT000000036639 FALSE
07-751471OP FALSE
46-733353OP FALSE
45-766408OP FALSE
45-740471OP FALSE
46-718931DP FALSE
46-750689OP FALSE
45-764701OP FALSE
PYMNT000000024657 FALSE
9081-1033357OP FALSE
46-762451DP FALSE
46-743492DP FALSE
4042-761027.1 FALSE
PYMNT000000036506 FALSE
PYMNT000000036902 FALSE
PYMNT000000055859 FALSE
9098-1023380DP FALSE
PYMNT000000056239 FALSE
PYMNT000000036984 FALSE
PYMNT000000056064 FALSE
PYMNT000000036392 FALSE
07-718023.1 FALSE
PYMNT33119MOVE FALSE
6081-773916 FALSE
PYMNT000000034916 FALSE
2520-738130OP FALSE
50-670450OP FALSE
45-755645OP FALSE
PYMNT000000036900 FALSE
45-659754.1 FALSE
6078-759361.1 FALSE
07-716722.1 FALSE
PYMNT000000055130 FALSE
9098-1036103DP FALSE
46-725291OP FALSE
07-712080.1 FALSE
9096-1040090DP FALSE
6083-657419DP FALSE
9098-1036104DP FALSE
2015-508690.1 FALSE
PYMNT000000056329 FALSE
46-776542 FALSE
46-769124OP FALSE
46-766602OP FALSE
46-762416OP FALSE
07-718003.1 FALSE
46-743411DP FALSE
PYMNT000000025365 FALSE
PYMNT000000036969 FALSE
60-024598WOFF FALSE
PYMNT32420MOVE FALSE
07-597720.1 FALSE
4042-750076.1 TRUE
46719867DP TRUE
46-718931WOFF TRUE
35-548425.3 TRUE
07-710788.1 TRUE
07-712081.1 TRUE
45-760737OP TRUE
6078-686225CM TRUE
45-726954DP TRUE
PYMNT39991MOVE TRUE
07-639042.1 TRUE
07-705725.1 TRUE
46-727284.1 TRUE
6078-759621.1 TRUE
9081-1017532 TRUE
46-760027.1 TRUE
07-723926.1 TRUE
46-768324 TRUE
6078-769952.1 TRUE
07-714308.1 TRUE
35-584005 TRUE
9120-371556.1 TRUE
9121-760523 TRUE
46-774114 TRUE
46-754921OP TRUE
46-719034.1 TRUE
6078-767405.1 TRUE
45-680064DP TRUE
46-766802OP TRUE
1040-761151.3 TRUE
PYMNT000000036811 TRUE
07-755547OP TRUE
01-701339.1 TRUE
9098-1035363DP TRUE
6076-766043OP TRUE
80-0002736.1 TRUE
06-775269DP TRUE
80-730044 TRUE
PYMNT000000036952 TRUE
4042-721655DP TRUE
46-743737DP TRUE
07-693958.1MOVE TRUE
07-723924.1 TRUE
35-773600 TRUE
9121-777405 TRUE
6078-765694.1 TRUE
46-743410DP TRUE
46-760027.2 TRUE
46-728508.1DP TRUE
PYMNT0008223 TRUE
07-743862 TRUE
9121-522023 TRUE
PYMNT000000036907 TRUE
46-735818.1 TRUE
46-730862.1 TRUE
6076-512802.1 TRUE
PYMNT000000036460 TRUE
6083-744024OP TRUE
46-716262.1 TRUE
46-759187OP TRUE
6083-744023OP TRUE
PYMNT000000036795 TRUE
6087-568547.1 TRUE
6087-568553.1 TRUE
46-749815OP TRUE
06-696756DP TRUE
PYMNT32227MOVE TRUE
46-764109.1 TRUE
60-030221DP TRUE
4042-746887.1 TRUE
46-718899OP TRUE
45-762556OP TRUE
6081-669722.1 TRUE
07-704923.3 TRUE
45-751665OP TRUE
PYMNT32189MOVE TRUE
45-763623DP TRUE
6081-649092WOFF TRUE
6078-721237.1 TRUE
01-749670OP TRUE
PYMNT000000009012 TRUE
46-719107.1 TRUE
46-746842CM TRUE
PYMNT000000036882 TRUE
PYMNT000000036205 TRUE
45-732668CM TRUE
PYMNT000000020470 TRUE
60-029752DP TRUE
01-780673 TRUE
6076-669129.2DP TRUE
PYMNT000000036883 TRUE
6078-581571 TRUE
PYMNT000000036827 TRUE
9007-611542.1 TRUE
PYMNT34395MOVE TRUE
PYMNT44435MOVE TRUE
PYMNT4751MOVE2 TRUE
6082-755506 TRUE

Using =ISNUMBER(LOOKUP(2^15,SEARCH(CHAR(ROW(INDIRECT("65:90"))),A1))) I received the same inconsistencies. I've tried changing the Format from General to Text and that didn't work either. I'm doomed aren't I?

Inv#
4042-721655DP TRUE
46-743737DP TRUE
07-693958.1MOVE TRUE
07-723924.1 TRUE
07-723926.1 FALSE
07-697702.1 FALSE
07-699161.1 FALSE
07-699898.1 FALSE
07-702622.1 FALSE
07-704205.1 FALSE
07-737468.1 FALSE
07-713772.1 FALSE
50-740574OP FALSE
07-708960.1 TRUE
07-708964.1 FALSE
07-710789.1 FALSE
07-710791.1 FALSE
07-712293.1 FALSE
07-715423.1 FALSE
07-716724.1 FALSE
07-718018.1 FALSE
07-720814.1 FALSE
07-720818.1 FALSE
07-720820.1 FALSE
07-723922.1 FALSE
07-723934.1 FALSE
45-732186OP FALSE
07-751471OP TRUE
46-776542 TRUE

=ISNUMBER(SUMPRODUCT(FIND(MID(A1,ROW(INDIRECT("1:"&LEN(A1))),1),"0123456789"))) returns "False" on everything.

And, XOR LX, I apologize. I've only used the forum a few times I was not aware that was an option. Please post the steps to attach the spreadsheet? I see where I can attach an image file or a link. I am sorry - like I said, I've only posted here a few times.

Alkey = how did you attach the spreadsheet? It's probably obvious...but I'm not seeing it.

And, thank you. I figured out what I was doing wrong. I was leaving the "A1" in the formula but the refernce cell should have been "A2". Once I changed that in the formula for yours and XOR LX's it did give me correct answers. I am so sorry. I appreciate all of the replies! This has been a report I've had to create every month for the past year and will continue to create every month. I am slowly learning new tricks through the experts how to cut the weeks to compile the report, down to just days!! This formula is going to be very helpful in the future!

Thank you to all of you!!!!!! You have all been so very helpful and I so appreciate your time!!!
Terri

Ron: See attached copy of what I am working with.

However, both of these formulas ended up working correctly:

=IF(ISERROR(--SUBSTITUTE(SUBSTITUTE(A2,"-","")," ","")),"TRUE","FALSE")

=ISNUMBER(LOOKUP(2^15,SEARCH(CHAR(ROW(INDIRECT("65:90"))),A2)))

ALKEY: thank you for showing me the "GO ADVANCED" function.

Originally Posted by XOR LX

@AlKey

Thanks for putting that together

Most definitely! I was afraid XOR LX was about to hop a plane to head bop me! LOL