How To Limit The Word Length Or Number Of Characters In A Cell

[papabill]

I'm using a two column list of words, and I need the first column of words to be exactly 8 letters or less. How can I limit the length of the words in this column to 8 letters?

Thanks

[alansidman]

On the Excel Ribbon, Click on the Data Tab. Select Data Validation. Select Data Validation again.

In the allow box, select text length
In the data box, select less than
In the maximum box, select 9

Click ok.