 |
| |||
|
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 | ||||
|
||||