MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Limit the number of characters within a column

Posted by Scott A on September 10, 2001 12:47 PM

I am using Excel to create CSV files. I need to limit one of the columns in Excel to only allow 30 characters. Can Excel do this?? If so how??


Posted by Mark O'Brien on September 10, 2001 12:56 PM

Yes, select all the cells that you want to limit the length to 30 chars. Go to Data|Validation, then in the "About" box select "Text Length". You can then choose "Less Than" etc. to set you limit.

You can also put in an error message that will show if the user tries to put in data that is longer than 30 characters.

Posted by Juan Pablo on September 10, 2001 12:57 PM

Select the entire column, select Data - Validation. Select "Length of text", "less than", 30

That way if the user enters a text that exceeds 30 an error message will appear.

Hope that helps

Juan Pablo