I'm looking for a function, that will look at a row of values in column b (for example) to see if it complies with approved naming convention. Naming convention must be as follows: <6 numbers><Single Space><Alpha with or without spaces>
If compliance is met, then do nothing. If compliance isn't met (error), place an 'x' in column a.
Example of Good:
555789 Red Apple
123456 I Love Excel
Example of Bad (to illustrate)
555555Food (no space between number and word)
555789 Red!Apple (special character)
I Love Excel 123456 (number at end, alpa at start)
55555 Smith (only 5 numbers at start)
555-123 Smich (first 6 characters not numeric)
Can anyone help me with a function / macro?
Thank you very much.