Limit number of characters in a cell

  • Thread starter Thread starter roma92
  • Start date Start date
R

roma92

Using Excel 97, and its most likely me, but I cannot find/figure out ho
I can limit the number of characters entered into a cell withing
column.

Example column A is entitled "Vendor ID" and has a maximum length of
alpha/num. I need to prevent AP from entering in say 123456, limitin
it to 12345.

thanks kindly for any assistance offere
 
You can use Data Validation to do this. Select the cells whose
values you want to restrict, and choose Validation from the Data
menu. In that dialog, choose 'Text Length' in the Allow box,
enter the appropriate values for the length.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
 
One method is through Validation although Validation is
easily defeated through copying and pasting over the cell
with Validation. It's good for preventing innocent keying
errors, not stopping curious but dangerous XL users.

1. Select column A.
2. Data > Validation
3. Allow: Custom
4. Formula:
=LEN($A1)<=5

HTH
Jason
Atlanta, GA
 
Back
Top