Tracy
You can use the PROPER Function.
A1 reads TRACY
In B1 enter =PROPER(A1) to return Tracy
Double-click on fill handle of B1 to increment the formula down column B as
far as you have data in column A.
If Upper case cells are many and spread out all over the place, you could use
a macro.
See David McRitchie's site for code.
http://www.mvps.org/dmcritchie/excel/proper.htm
Gord Dibben Excel MVP
On Fri, 11 Feb 2005 10:59:05 -0800, "Tre1"
wrote:
i am trying to change the casing in my text from all upper case to just the
first letter Example: TRACY = Tracy. Can you help me anyone please I dont
want to retype the whole work sheet