Limiting text

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How do I limit the number of characters that can be entered into a cell?

Thanks
 
Hi
'Data - Vaidation' and specify your max number of characters
 
Maybe Data > Validation ?

Select the cell

Click Data > Validation

Make the settings:
Allow: Text length
Data: less than
Maximum: 5 (say)

Click OK

Now test it out by entering into the cell
say, a text phrase > 4 characters
(You should get the error message)
 
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

The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Code character limit with Resize or Transpose or cell? 8
Moving extra characters to a new column 12
string width 8
Limit Number Of Characters Allowed In A TextBox 4
go to next cell after specified # of characters typed 2
Column Cell character number checking 4
Problem with text in cell 2

Back
Top