General Discussions

Discuss any topics that are not product-specific here.

To Limit the Digits inside Column

selinunlu
7 - Meteor

hello everyone,

 

I want to limit digits in columns. Firm name can be max 72 digit and tax number should 10 or 11 but there are many numbers with 9 digits.So which formula should be used for this?

 

 

selinunlu_0-1647451178646.png

 

2 REPLIES 2
atcodedog05
22 - Nova
22 - Nova

Hi @selinunlu 

 

If you want to only check you can do like below.

 

atcodedog05_0-1647451996943.png

 

 

Hope this helps : )


Can you provide some sample input and expected output It will help us get a better understanding of the usecase.

We will be happy to help : )

selinunlu
7 - Meteor

Thanks for help.

 

I couldn't get this. I want to see whole text in the  firm name check column. For example, if firm name AAAAAAAAAAB less than 72 digit I want to see all inside the cell but if it is higher than 72, I want to see the name till seventy-second digit.

Sincerely.

Labels