Is there any validation formula which don't allow to save some value in column with SPACE in SharePoint 2010? I know that is Calculate column formula with TRIM formula but I need to validation formula to give Notification that user should remove SPACE from TEXT.

I will be very grateful for support.

1 Answer 1


If the column name is "NoSpace", the validation formula is:

=ISERROR(FIND(" ",NoSpace))

enter image description here

This is the NewItem form:

enter image description here

  • This answer still works for Sharepoint Online too
    – Tally
    Commented Jun 18 at 12:45

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.