To change case in Excel you need to use an Excel function. The functions
are listed below.

=UPPER()
This function will change the case of a specified cell to upper case.

=LOWER()
This function will change the case of a specified cell to lower case.

=PROPER()
This function will change the case of a specified cell to title case
(ie The first letter of each word in the cell will be capitalised).

How To Use These Functions
Its easiest to illustrate the use of these functions through an
example. If, for example, you had the word "AbOut" in cell A1 and
wanted to change the case to lower case you would use the LOWER
function in a blank cell:

=LOWER(A1)

That cell would then display "about". If, instead you had used the
UPPER function would display "ABOUT", and using the PROPER function
would display "About". You could then use the "Paste Special" command
to replace the contents of A1.


--
FvH
------------------------------------------------------------------------
FvH's Profile: http://www.excelforum.com/member.php...o&userid=30709
View this thread: http://www.excelforum.com/showthread...hreadid=503768