This video demonstrates how to prevent users from entering values in Excel with leading, trailing or double spaces. It looks at two methods: the first uses conditional formatting and the second uses data validation. This is not the same as using the TRIM function which removes spaces from existing values - this video looks at preventing such entries in the first place.

This video will be useful if you are asking the following questions:

How do I use data validation to prevent spaces?
How do I use data validation to prevent leading spaces?
How do I use data validation to prevent trailing spaces?
How do I use data validation to prevent double spaces?
How do I use conditional formatting to prevent spaces?
How do I use conditional formatting to prevent leading spaces?
How do I use conditional formatting to prevent trailing spaces?
How do I use conditional formatting to prevent double spaces?
How do I write a formula to prevent spaces?
How do I write a formula for custom data validation?
------------------------