Limiting the Number of Characters in a cell of Column

A member of a discussion list asked a question earlier today and I answered it … thought you’d like to see the question and the answer!

In summary, he wants to limit column A to a width of 8 characters and column B to 25 characters in width. How to do that?

Data Validation is probably what you want S. In Excel 2007 you can do the following

  • Select the entire column A
  • Data … Data Tools … Data Validation: click on the down arrow
  • Select Data Validation
  • Allow … Text Length
  • Data … less than or equal to
  • Maximum … 8
  • OK

Now try to enter any combination of characters greater than 8 characters in length …

Repeat for column B with the maximum set to 25