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

Duncan Williamson

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.

%d bloggers like this: