data validation and formatting

Giganews Newsgroups
Subject: data validation and formatting
Posted by:  Laurie
Date: Mon, 1 May 2006

I want users to be allowed to enter a seven character response in a cell.
The seven character response must be in the following format - number number
letter letter number number number.  I specified the length of the entry by
using the data validation feature but I don't know how to ensure that the
response is in the right format.  I'm using Microsoft Excel 2002.  Any