Excel: Controlling a cells format - Alpha Numeric (x4) Alpha Alpha

Good day all, First post, never lurked. I'm confident you guys are the ones to ask though. In an existing sheet, I'd like to control the format of cells in a column. Namely restrict it to ANNNNAA (A=Text and N=numbers), 7 characters maximum as it's really meant to accept only existing unique ID numbers. I've tried to use \####\\ or "",####"","" which may or may not obviously work as a custom. As my understanding is at it's limit, I thought it time to ask for some help. Thank you all in advance and I hope to repay the favour at some point. Kind regards

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

This thread is current as of October 21, 2014.

For more resources for Microsoft Excel