Custom Alphanumeric Formatting using Data Validation

[Ebreezy757]

Hi guys,

I have tried to reverse engineer some formulas that I've found on the forum for my specific case, but I could never get them to work correctly. I was hoping someone might be able to help my lock the input of a cell down to this specific set of characters.

1. First character will always be a letter (text)
2. The next seven characters will always be numbers
3. The ninth character will always be a letter (text)
4. The last four digits will always be numbers.
5. I would like the letters to be remain capital letters

An example would be: N0018712A2345

Thanks in advance for any help you can provide!

 

[Ebreezy757]

Rick Rothstein and Tetra, you guys are awesome! Ultimately, the formula with the length test at the end worked perfectly. I REALLY APPRECIATE your hard work and THANK YOU!!

 

[Tetra201]

You are welcome.

 

[dritan0478]

Hi to all,

I need to restrict some data in the Excel cells

Here it is the scenarios:

AA:BB:CC:DD:WW:ZZ

Total character = 17
Allowed Numbers or Upper Letters Only
On the 3-rd,6-th,9-th,12 and 15-in position must be only ":" character.

So those are the rule that I want the cell in Excel to follow.

Could you help me on this?
Thank you,
Dritan