How to limit the maximum characters in a cel ?

A

Alexander Schek

Hi!

Thanks for your time and help...
I have a sheet and in one particular column, I need to LIMIT the size of the
words in there to 45 characters maximum, with no minimum. Is there a way I
can restrict this ?

Thanks!
Alex
 
A

Alexander Schek

Dan!
GREAT.. thanks a lot... perfect... just what I needed!
A question... does the SPACE count as a character ?
Thanks again!
Alex
 
D

Dan E

Yes

Dan E

Alexander Schek said:
Dan!
GREAT.. thanks a lot... perfect... just what I needed!
A question... does the SPACE count as a character ?
Thanks again!
Alex
Click to expand...
 

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

Can I restrict a text column to a specific number of characters? 4
Force line break based on text 3
How can i find the max value within a time range ased on two cells 6
Remove all formatting charactersf except for paragraph and cr/lf 0
Excel --> Word 4
Problem with MS Word paragraph and character styles: format getting messed up 2
xy-chart axes lower and upper limits dynamically set by data seriesvalues 0
How to dynamically set the lower and upper limits of the axes on a MSAccess xy-chart. 0

Top