Changing Case in Excel 2000

I have non-data in a column which is a mixture of upper and lower case charaacters. Is there a simple and quick way of changing all of these either to upper, lower, or title case similar to Word?