How to get mixed case in Excel, Microsoft Excel ?
How to fix anything
 
 
 
 
 
 

Search for :



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"

Previous Page    Next Page    IP

_________