Excel: Custom Alphanumeric Formatting using Data Validation

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!

This question generated 11 answers. To proceed to the answers, click here.

This thread is current as of July 21, 2017.

For more resources for Microsoft Excel