Changing text

[Kim]

I am trying to change text from all caps to lowercase or
like you can in word. Not finding it. Does it have
to be a formula and if so..please give details.

 

[J.E. McGimpsey]

Take a look at David McRitchie's Lowercase() macro:

http://www.mvps.org/dmcritchie/excel/proper.htm#lower