Limiting Characters In Rows

M

Mdlee

How do you format a column so that It only has a limited amount o
characters. Some rows in my column have over 40 characters which i
the limit. I need to cut off the characters at 40 for the complet
column. I have thousands of rows and I don't want to do this manually


Thanks for the help!

Michael Le
 
B

Biff

Hi!

You can use data validation.

Assume the range in question is A1:A10.

Select that range
Goto Data>Validation
Allow: Text length
Fill in the criteria
OK out

Biff
 
Top