HOW CAN I LIMIT QUTITY OF LETTERS IN A CELL?

  • Thread starter Thread starter Guest
  • Start date Start date
You can use Data Validation (on the Data menu) at set the Text
Length option to the maximum length.

Also, please do not post in all CAPS. It is considered rude and
is difficult to read.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
 
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

How to type each letter of the alphabet automatically in a specific color in Word? 0
Count occurences of a letter in a cell 2
TRIM IF CELL CONTAINS ONE WORD, ABBREVIATE IF IT CONTAINS MULTIPLE WORDS 1
How to I set a limit on the value returned by a cell 3
Restricting Cell entry to certain letters 7
Custom Formating Letters to Numbers while Displaying Letters 2
Excel Use COUNTIF across a range of cells with formulas 0
use month in cell date to sum all relevant cells 2

Back
Top