Limiting Characters In Rows

  • Thread starter Thread starter Mdlee
  • Start date Start date
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
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Excel text export limit - 1024 per line (not cell), workaround? 11
LIMITING DATA VALIDATION ENTRIES 1
Excel character limitations 1
Counting characters in Excel 2
Limiting text entries 7
Autofit single cell text 3
"Centre Across Selection" and character limit 1

Back
Top