MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Maximum Limit # of Characters


Posted by Anita Hayes on January 02, 2002 7:50 PM

How do you put a maximum size limit on any given column ?

I have a column that cannot exceed 255 characters
including spaces, how and where do I enter
that 255 alphanumeric character limit ??


Posted by Juan Pablo G. on January 02, 2002 8:16 PM

Use Data - Validation: Select the column, go to Data - Validation, then select Text Length, and use "less than or equal to", and put 255 in the textbox you have there.

Juan Pablo G.

Posted by Jack in UK on January 03, 2002 11:40 AM

Hi--
maybe ive got it wrong but why valadate, Excel wont allow a return in text over 256 or 255?? Characters, i hit this limit every day, so have to do in two sections and copy Paste/value and add the new data in front, my formulas are so lond and then & CHAR(10) & " ....... "
So thats my workarround the Formula can have 100+ charcter but data returned can be 25 you see the issue, but i cant force Excel more..

HTH
Jack