Limit to 50 char only

  • Thread starter Thread starter singkit
  • Start date Start date
S

singkit

Help!
Is there a way we can limit the column to 50 character
only and it will not accept data exceeding from the limit
you set.

Thanks.
 
Hi
try the following:
- select the cell (lets say A1)
- goto 'Data - Validation' and choose 'Custom'
- enter the formula
=LEN(A1)<=50

Note: this won't prevent copying longer data into this cell
 
Or, more simply maybe....

Data>Validation>Allow "Text Length" less than 51

Gord Dibben Excel MVP
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Limit worksheet for 50 rows only 6
Code character limit with Resize or Transpose or cell? 8
For next loop suddenly not working, any ideas? 2
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
limit character length when copying or typing 5
Hide / Unhide each row from StartRow to LastRow for multiple conditions 6
Text To Column max 26 characters 7
Too much data for this code? 4

Back
Top