Advanced VLookup trick with Data Validation in Excel
If you have any complex criteria then you can use VLookup trick with Data validation. It allows you to search value as per given condition.
Data-Validation
Remove spaces with Data Validation in MS Excel
If you want to prevent spaces in text string in MS Excel then you can easily remove spaces with Data Validation in MS Excel along with TRIM Function.