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”


About Author

Comments are closed.

Please note we do not accept any responsibility for errors occurring During Use of this site users follow instructions listed at their own risk.