Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
YIZHENG
 
Posts: n/a
Default HOW CAN I LIMIT QUTITY OF LETTERS IN A CELL?

I WANT LIMIT THE QUANTITY OF LETTERS IN A CELL, HOW CAN I DO THIS?
  #2   Report Post  
Chip Pearson
 
Posts: n/a
Default

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

"YIZHENG" wrote in message
...
I WANT LIMIT THE QUANTITY OF LETTERS IN A CELL, HOW CAN I DO
THIS?



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
separating numbers and letters from alphanumeric cell contents PH Excel Worksheet Functions 10 September 3rd 05 12:15 PM
Change colour of Text if number in cell exceed limit Lewis Koh Excel Worksheet Functions 2 August 2nd 05 02:16 AM
Possible Lookup Table Karen Excel Worksheet Functions 5 June 8th 05 09:43 PM
increase cell 255 limit in excel2000 help or way round it? lisa Excel Discussion (Misc queries) 3 May 20th 05 12:39 AM
up to 7 functions? ALex Excel Worksheet Functions 10 April 12th 05 06:42 PM


All times are GMT +1. The time now is 11:12 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"