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
Search for the function called "proper" Previous Page Next Page IP