Convert text fields in Excel to Proper case
Excel provides an easy formula to set text values in cells to the correct or proper case. This is very helpful when cleaning up data before entering into a database. If the source was from a third-party -- perhaps from user registrations, it's not unusual to have users not capitalize proper names.
Here's an example:
Here's an example:
- You want st. paul to read St. Paul
- You want project manager to read Project Manager
- =PROPER(A1) where A1 is the cell of the value you want to convert
- =TEXT(PROPER(A1),"#")
- =UPPER(A1)
Comments