How to fix anything

Search for :

Google this page is not a duplicate

How to get mixed case in Excel, Microsoft Excel ?

In the cell enter "=proper(value)"

This will display the value as mixed case

e.g "mr peter conway" or "MR PETER CONWAY" will be displayed as "Mr Peter Conway"

For more information look at help in Excel, Press F1

Under "Functions"

Search for the function called "proper"    IP