productivity through technology
Excel’s PROPER function capitalises the first letter in a text string and any other letters in the text that follow any character other than a letter. The function converts all other letters to lowercase letters.
In the example below, the function =PROPER(A2) has been entered in cell B2 and then copied down using Auto Fill.
Mister Fox AKA @MisterFoxOnline is an ICT, IT and CAT Teacher who has just finished training as a Young Engineers instructor. He has a passion for technology and loves to find solutions to problems using the skills he has learned in the course of his IT career.