Warning: Use of undefined constant result - assumed 'result' (this will throw an Error in a future version of PHP) in /data01/hpcsolut/public_html/howtofix/dynamic.php on line 36

Warning: Use of undefined constant pagename - assumed 'pagename' (this will throw an Error in a future version of PHP) in /data01/hpcsolut/public_html/howtofix/dynamic.php on line 46

Warning: Use of undefined constant pagename - assumed 'pagename' (this will throw an Error in a future version of PHP) in /data01/hpcsolut/public_html/howtofix/dynamic.php on line 52

Warning: Use of undefined constant id - assumed 'id' (this will throw an Error in a future version of PHP) in /data01/hpcsolut/public_html/howtofix/dynamic.php on line 54

Warning: Use of undefined constant count - assumed 'count' (this will throw an Error in a future version of PHP) in /data01/hpcsolut/public_html/howtofix/dynamic.php on line 58

Warning: Use of undefined constant debug - assumed 'debug' (this will throw an Error in a future version of PHP) in /data01/hpcsolut/public_html/howtofix/sqlfunctions.php on line 184

Warning: mysqli_num_rows() expects parameter 1 to be mysqli_result, bool given in /data01/hpcsolut/public_html/howtofix/dynamic.php on line 449

Warning: Use of undefined constant pw - assumed 'pw' (this will throw an Error in a future version of PHP) in /data01/hpcsolut/public_html/howtofix/dynamic.php on line 515

Warning: Use of undefined constant result - assumed 'result' (this will throw an Error in a future version of PHP) in /data01/hpcsolut/public_html/howtofix/menu.php on line 3

Warning: Use of undefined constant type - assumed 'type' (this will throw an Error in a future version of PHP) in /data01/hpcsolut/public_html/howtofix/search.php on line 3
How to get mixed case in Excel, Microsoft Excel ?
How to fix anything
 About Us | Which Computer? | Memory Stick | Copy File | Site Map | 
What is a Browser | Search Engine | Windows Explorer 


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

©Copyright HPC Solutions Limited - All rights reserved (2012/13) .
Please note we do not accept any responsibility for errors occurring During Use of this site users follow instructions listed at their own risk.