Microsoft Office Tips and Tricks

Making Proper Names in Excel

Lets say you have a lot of data that's in all caps or in lower case, such as Ship Names (ENTERPRISE, LEXINGTON, YORKTOWN, essex, bon homme richard) and you would like to have it all properly formatted (Enterprise, Lexington, Yorktown, etc).

Use the =PROPER() function for this. If your data is in the A2 cell, then the fixed data formula would be =PROPER(A2).