Tip of the Week #90 – Quickly Capitalize/Clean Up Names in Excel

Tip of the Week #90 – Quickly Capitalize/Clean Up Names in Microsoft Excel

Project Manager Torben Nielsen brings us this week’s helpful tip.

Excel provides lots of features. Did you know about this one?

Imagine your task is to capitalize a list of poorly formatted names, such as a customer list.

Suppose you have this badly formatted list in Excel:

Problem: Names not all are capitalized properly, some starting with lower case, some being all uppercase etc.

Solution:

Step 1: In cell B1 start typing like this:

Step 2: Hit enter

Step 3: Start typing “Onie”, and see what happens:

By now Excel will have you figured out – and will suggest what to do with your remaining data.

Step 4: Hit Enter, to approve Excel’s suggestion.

Step 5: Result: A nicely formatted list of customer names.

Celebrate time saved by getting a fresh cup of coffee.

Enjoy!

Thank you Torben!