Data Validation 7 - Prevent Spaces From Being Entered Before or After Text in Excel

Visit http://www.TeachExcel.com for more, including Excel Consulting, Macros, and Tutorials.

Excel video tutorial showing you how to use Data Validation in Excel in order to prevent a user from entering a space before or after text in a cell in Excel. This teaches you how to prevent leading or trailing spaces from being entered into cells. The benefit of checking for this and of preventing a user from entering such as value is so ensure that functions and formulas that reference the original cells input will be able to work. For instance, vlookup, match, and index lookup functions will look for exact matches of data and leading and trailing spaces can prevent these functions from working correctly.

This is a perfect example of why data validation exists in Excel and of where it can be most useful. This Excel video tutorial covers the custom attribute of data validation in Excel.

For Excel consulting, classes, or to get the spreadsheet or macro used here visit the website http://www.TeachExcel.com There, you can also get more free Excel video tutorials, macros, tips, and a forum for Excel.

Have a great day!

Category:

Education

Tags:

• excel
• data validation
• trim
• prevent
• spaces
• entered
• cells
• leading
• trailing
• stop