Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
how do i change the case text in a column?
I followed the directions as listed under CLR's post, however I am unable to
figure out how to copy down the column as well. |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
how do i change the case text in a column?
Would have been nice if you had stuck to the original thread but in the absence
of any detail................... Enter =casefunction(A1) in B1 Double-click on the fill handle of B1 to copy down. casefunction would be LOWER, UPPER or PROPER depending upon your needs. Gord Dibben MS Excel MVP On Tue, 17 Apr 2007 11:56:01 -0700, Changing the case and copying down <Changing the case and copying wrote: I followed the directions as listed under CLR's post, however I am unable to figure out how to copy down the column as well. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Change the text from lower case to upper case in an Excel work boo | Excel Discussion (Misc queries) | |||
Change Text Case | Excel Worksheet Functions | |||
How do I change a column in Excel from upper case to lower case? | Excel Worksheet Functions | |||
how do I change case in an entire column of text in Excel | Excel Worksheet Functions | |||
How do I change existing text from lower case to upper case | Excel Discussion (Misc queries) |