software

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: www.excelforum.com/member.php...oamp;userid=34477
View this thread: www.excelforum.com/showthread...hreadid=542350Hi!

You can use data validation.

Assume the range in question is A1:A10.

Select that range
Goto Datagt;Validation
Allow: Text length
Fill in the criteria
OK out

Biff

quot;Mdleequot; gt; wrote in
message ...
gt;
gt; How do you format a column so that It only has a limited amount of
gt; characters. Some rows in my column have over 40 characters which is
gt; the limit. I need to cut off the characters at 40 for the complete
gt; column. I have thousands of rows and I don't want to do this manually.
gt;
gt;
gt; Thanks for the help!
gt;
gt; Michael Lee
gt;
gt;
gt; --
gt; Mdlee
gt; ------------------------------------------------------------------------
gt; Mdlee's Profile:
gt; www.excelforum.com/member.php...oamp;userid=34477
gt; View this thread: www.excelforum.com/showthread...hreadid=542350
gt;