|Subject:||data validation and formatting|
|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