Text length with no spaces.

[countryfan_nt]

Hello friends,

I am trying to create a Data validation > Allow text length. And I want to have the maximum value 10 without "Spaces". I tired to do that with several ways but still lost.

Your help is always appreicated.

Thanks,
Nawaf

 

[Peter_SSs]

Hello friends,

I am trying to create a Data validation > Allow text length. And I want to have the maximum value 10 without "Spaces". I tired to do that with several ways but still lost.

Your help is always appreicated.

Thanks,
Nawaf

Instead of using 'Allow text length' try 'Custom' and this 'Formula' (assuming A1 is the cell in question):
=LEN(SUBSTITUTE(A1," ",""))<=10

 

[countryfan_nt]

Thank you!
It works,

Nawaf