Mitigating campaign name errors

The Marketing Director has requested that you create a spreadsheet with all of the campaign data, which means that multiple people from different specialties will be contributing their data to the spreadsheet. With your knowledge of data validation, you know that multiple parties entering data should not result in unclean or un-usable data if the correct data validation is used.

What would be an effective way of mitigating spelling errors or variations in the Campaign Name column of the spreadsheet?