Max length

[CiaoPaola]

Hi, 

I have a long list of phone numbers which need to be formated with the International phone number format. 

the numbers cannot exceed 15 chars. 

How can I filter the phone numbers which are equal or less than 15 chars and the rest of them ?

thank you 

Paola 

[Emil_Kos]

Hi,

you need to use the filter tool and use the formula below:

Length([test])<=15

The length formula will check how long the value is and we just need to check if it is equal to or smaller than 15

[CiaoPaola]

thank you Emil! 😉