Hi!
You can use data validation.
Assume the range in question is A1:A10.
Select that range
Goto DataValidation
Allow: Text length
Fill in the criteria
OK out
Biff
"Mdlee" wrote in
message ...
How do you format a column so that It only has a limited amount of
characters. Some rows in my column have over 40 characters which is
the limit. I need to cut off the characters at 40 for the complete
column. I have thousands of rows and I don't want to do this manually.
Thanks for the help!
Michael Lee
--
Mdlee
------------------------------------------------------------------------
Mdlee's Profile:
http://www.excelforum.com/member.php...o&userid=34477
View this thread: http://www.excelforum.com/showthread...hreadid=542350