Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Proper text
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 |
#2
|
|||
|
|||
Take a look at
http://www.mvps.org/dmcritchie/excel/proper.htm In article , "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 |
#3
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Why is my text changing to pound signs? | Excel Discussion (Misc queries) | |||
Using PROPER for Columns, rows or ENTIRE spreadsheet | Excel Worksheet Functions | |||
Read Text File into Excel Using VBA | Excel Discussion (Misc queries) | |||
convert a column of text to proper | New Users to Excel | |||
How to change text in multiple cells from Uppercase to proper cas. | Excel Worksheet Functions |