You can use Data Validation (on the Data menu) at set the Text
Length option to the maximum length.
Also, please do not post in all CAPS. It is considered rude and
is difficult to read.
--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
