Data Validation will do (most of) this.

On "Allow" choose "Text Length" and set the minimum and maximum values.
Your user will only be allowed to enter text within the values set.

Why, "most of"? Because the user can try and type in as much as he wants;
only when he presses "Enter" will the restriction be invoked.

--
Andy Wiggins FCCA
www.BygSoftware.com
Excel, Access and VBA Consultancy
-

"Smitty52" wrote in message
...
I want to restrict entries to an Excel Cell to 6 characters, the first two
must be capitalized alpha characters and the following four can be any
digit.
I know I can probably do this in Access, but how do i do it in Excel?
I have Office 2003