Changing Case In Excel

[mikmahone]

If you type in the wrong case in word, you can hit shift
F3 and it changes the case (e.g. lower to caps etc). Is
there any way to do this in Excel?

 

[lynn hwee]

If your text is in say, A1. At a different cell, say
B1,you can use the following formula:
1) to change the string to upper case: =upper(cell
reference)
2) to change the string to lower case: =lower(cell
refernce)
3) to change the string to sentence case: =proper(cell
reference)

Then copy and paste value of B1 to remove the formula.

Lynn

 

[Dave Peterson]

Chip Pearson has some macros at:
http://www.cpearson.com/excel/case.htm
That you might like.

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm