Leading the way in Microsoft Office Development

Step 1 - Highlight the cells

There may come a time when you want to restrcit the exact format of a text string.

In this example we want the string to be exactly 5 characters long and to start with a letter.

Step 2 - Enter the Conditions

=AND(LEN(C6)=5,CODE(LEFT(UPPER(C6),1))>64,CODE(LEFT(UPPER(C6),1))<91)

Press OK to apply the data validation.