KayJay0618
New Member
- Joined
- Jul 20, 2016
- Messages
- 40
I have looked and cannot find anything to help. End users will be copying data with several hundred to several thousand records from an external source (to which they cannot connect) into a template I've created to help them identify keying errors in the source. The product number (which must contain exactly 9 numeric digits) must not contain alpha characters. In some cases there is appropriately a leading zero. I need a formula that will identify when an alpha character or a special character exists in the product number column. I already have the formula to identify short and long product numbers. Below is a sample. I would need to identify that row 4 has an alpha character and that row 6 has a special character. Data validation doesn't do the trick for me.
<tbody>
</tbody><colgroup><col><col><col><col><col><col><col><col><col></colgroup>
A | B | C | D | E | F | G | H | |
1 | ID | Cust No | CustLast | CustFirst | DA | PA | PSA | ProductNo |
2 | AJ0779781229 | 4097992 | Smith | WILLIAM | E | 76 | 140136334 | |
3 | 767561 | 4147116 | Jones | ROCHELLE | 380 | E | 76 | 146132497 |
4 | 410927 | 4598452 | Jackson | Sue | 134 | E | 76 | 1460B4370 |
5 | 782299 | 4598452 | Jackson | Sue | 134 | E | 76 | 146131696 |
6 | 189336 | 4444486 | Adams | Pago | 120 | E | 76 | 14-106687 |
7 | RM1402000056 | 4001248 | Matthews | Amancio | 134 | E | 76 | 142006190 |
8 | RM1405000117 | 4001248 | Matthews | Amancio | 134 | E | 76 | 142040328 |
9 | 492158 | 4249567 | Everly | Robert | 134 | E | 76 | 146108574 |
<tbody>
</tbody><colgroup><col><col><col><col><col><col><col><col><col></colgroup>