I would like to format a cell so that is will only accept entries in this format, 2 letters, 2 numbers, 1 letter, 2 numbers (AA02D03)
Is this possible? If so, how?
Thanks.
I would like to format a cell so that is will only accept entries in this format, 2 letters, 2 numbers, 1 letter, 2 numbers (AA02D03)
Is this possible? If so, how?
Thanks.
Use Data Validation with Custom and use this formula:
Formula:Please Login or Register to view this content.
Replace A1 with the actual cell.
I assumed all the letters are uppercase.
Jeff
| | |·| |·| |·| |·| | |:| | |·| |·|
Read the rules
Use code tags to [code]enclose your code![/code]
VBA method.
User defined function like below in standard module.
You then add following to worksheet module (change range from A1:A100 to target range of your choice).Please Login or Register to view this content.
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks