LinkBack URL
About LinkBacks
Stan5582 
Hi Marvin, don't you need capitalization criteria and total string length criteria? Or can this be entered as separate validation criteria?
Hi Marvin, don't you need capitalization criteria and total string length criteria? Or can this be entered as separate validation criteria?
Hi Xx7,
I simply used your first half of the data validation and took from character 3 to 10 and tried to see if it was all numbers. It made my formula a little shorter and allowed for 1 to 7 numbers after the first 2 letters. No UCASE involved with my formula.
One test is worth a thousand opinions.
Click the * Add Reputation below to say thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks