Mandatory force no space in between character

Hi There

Is there a way to force the entry data user from entry space in between? E,.g A Bc and I want to force enty data ABC i.e. no space and all UPPER CASE

I do not think you can force the user but you can correct their entries when the data is saved.

1 Like

This?

AND(
  NOT(CONTAINS([_THIS], " ")),
  (FIND(UPPER([_THIS]), [_THIS]) = 1)
)
4 Likes

Work perfect

1 Like

@Steve BRILLIANT!!!

1 Like