ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Limiting a Column to "X" Number of Characters (https://www.excelbanter.com/excel-discussion-misc-queries/192605-limiting-column-x-number-characters.html)

Wayne

Limiting a Column to "X" Number of Characters
 
Is there a way to limit a column to 33 characters in length? We are using
Excel 2003.

Thanks for any help.

Wayne

Marcelo

Limiting a Column to "X" Number of Characters
 
use data -- validation

Select on box allow: Text length
Data: Less than
Maximum 33

hth
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"Wayne" escreveu:

Is there a way to limit a column to 33 characters in length? We are using
Excel 2003.

Thanks for any help.

Wayne


MyVeryOwnSelf

Limiting a Column to "X" Number of Characters
 
Is there a way to limit a column to 33 characters in length? We are
using Excel 2003.

Thanks for any help.

Wayne


use data -- validation

Select on box allow: Text length
Data: Less than
Maximum 33


Be aware though, that data validation works only for typed-in values.
Somebody can paste in a value that violates the limit.


All times are GMT +1. The time now is 08:43 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com