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
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
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.