Go Back  DVD Talk Forum > General Discussions > Tech Talk
Reload this Page >

Excel question - Limiting # of char's in a cell?

Tech Talk Discuss PC Hardware, Software, Internet and Other Technology

Excel question - Limiting # of char's in a cell?

Old 02-01-03, 11:50 AM
  #1  
DVD Talk Limited Edition
Thread Starter
 
Join Date: Sep 2000
Location: CT
Posts: 5,177
Likes: 0
Received 0 Likes on 0 Posts
Excel question - Limiting # of char's in a cell?

in excel (xp), is there any way to limit the amount of text that can be entered into a single cell? i have a column that i do not want to exceed a certain number of characters... can it be done? how? TIA.
Old 02-01-03, 12:12 PM
  #2  
DVD Talk Special Edition
 
Join Date: May 2000
Location: LA
Posts: 1,388
Likes: 0
Received 0 Likes on 0 Posts
Yes, select your column and go to the following menu: Data -> Validation. There's a drop down for you to set text length limits. You can then go to the error alert tab to create a popup warning when it's too long.
Old 02-01-03, 12:28 PM
  #3  
DVD Talk Limited Edition
Thread Starter
 
Join Date: Sep 2000
Location: CT
Posts: 5,177
Likes: 0
Received 0 Likes on 0 Posts
cool, thanks UWS. one thing - that works, but... is there any way for it to stop me from entering more text after my given amount of characters (45)? seems with the method you gave, it will let you type as much as you want, and not tell you about it until you're done entering data into that cell.. thanks again!
Old 02-01-03, 12:52 PM
  #4  
DVD Talk Special Edition
 
Join Date: May 2000
Location: LA
Posts: 1,388
Likes: 0
Received 0 Likes on 0 Posts
I can't think of any way of doing it. Excel seems to only tell you of data entry problems after the fact. The only thing I can think of is to adjust your column width to fit in just 45 characters as a rough indicator.
Old 02-01-03, 12:55 PM
  #5  
DVD Talk Limited Edition
Thread Starter
 
Join Date: Sep 2000
Location: CT
Posts: 5,177
Likes: 0
Received 0 Likes on 0 Posts
not a bad idea.. i'll just have to change to a fixed-width font.. thanks!
Old 02-01-03, 07:24 PM
  #6  
DVD Talk Hero
 
D.Pham4GLTE (>60GB)'s Avatar
 
Join Date: Jul 2001
Location: Stick out your tongue!
Posts: 39,346
Likes: 0
Received 0 Likes on 0 Posts
i think that there was a limit of 8 characters in an old old old version of excel. the reason why i know this is because it was a test question in one of my classes a few years back.

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

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


Thread Tools
Search this Thread

Archive - Advertising - Cookie Policy - Privacy Statement - Terms of Service - Do Not Sell My Personal Information

Copyright 2018 MH Sub I, LLC dba Internet Brands. All rights reserved. Use of this site indicates your consent to the Terms of Use.