Maxlength Character in Excel cells

Hi,

I have one scenario.

I need to do while downloading a empty template.

I have done code by data validation.

Each column will have different character length.

Lets take i have to do validation for 3 columns (Column 8 - length 10, Column 9 - length 15, Column 10 - length 30)

When i apply Validation.Formula, it takes length of 30 to all the three columns.

Please advise me on above point to do data validation.

@Harish_Gopalan,

Thanks for your query.

I think you should implement text length validation type with different characters’ length on each range/area (Column 8 - length 10, Column 9 - length 15, Column 10 - length 30). See the document topic/sub topic with example for your reference:

Hope, this helps a bit.