Pre-Setting the number of characters input in a whole column

[tlee]

Hi all,

How can I pre-set the maximum number of characters to input in a whole
column?

If it is excess its limit, the warning message will pop up.

Thanks for in advance.

TLee

 

[Jacob Skaria]

From Menu Data>validation>Settings>Allow>TextLength

 

[tlee]

Hi Jacob,

It's very helpful. And how can I modify the Pop up warning message and its
button?

Thanks
TLee

 

[Patrick Molloy]

use the Error Alert tab in the Data Validation form

 

[tlee]

Hi Patrick,

Thank you very much for your information.

TLee