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…
#Data-Validation
2 postsAdvanced 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…