Set Character limit in Column

Id it possible to limit the number of characters in and Excel spreadsheet
column automatically to say i.e.34
--
NeilE

You could select the column
Data|Validation|Settings tab
Use Text Length and set it for what you want.

Be aware that this isn't foolproof--a user can paste over any of these cells and
destroy the data|validation rule.

And it won't stop them while they'er typing. It'll give them a warning/error
message when they enter the data.

For me, I like to use an adjacent column with a formula like:

=if(len(a1)34,"","--Text too long")
and make it bold and red.



NeilE wrote:

Id it possible to limit the number of characters in and Excel spreadsheet
column automatically to say i.e.34
--
NeilE

--

Dave Peterson

Thanks for this it is a good solution for the application that I am using.
--
NeilE


"Dave Peterson" wrote:

You could select the column
Data|Validation|Settings tab
Use Text Length and set it for what you want.

Be aware that this isn't foolproof--a user can paste over any of these cells and
destroy the data|validation rule.

And it won't stop them while they'er typing. It'll give them a warning/error
message when they enter the data.

For me, I like to use an adjacent column with a formula like:

=if(len(a1)34,"","--Text too long")
and make it bold and red.



NeilE wrote:

Id it possible to limit the number of characters in and Excel spreadsheet
column automatically to say i.e.34
--
NeilE

--

Dave Peterson