| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
TURN LOWER CASE TO UPPER CASE IN EXCEL?
Help tries to explain how to turn lower case to upper case but fails miserably!
Can someone walk me through it? |
|
#2
|
|||
|
|||
|
If the lower case text is in A1, type this formula in B1 =UPPER(A1).
-- Carlos "TommyG" wrote in message ... Help tries to explain how to turn lower case to upper case but fails miserably! Can someone walk me through it? |
|
#3
|
|||
|
|||
|
Tommy
Help says to enter a formula in a cell referring to another cell. i.e. A1 contain tommy In B1 enter =UPPER(A1) If you more than A1 with lower case, you can drag/copy the formula from B1 down column A. To drag/copy, hover the mouse pointer over the bottom right corner of B1 until you see a black cross. Click on that and drag down the column. =UPPER(A1) will change to =UPPER(A2) then =UPPER(A3) etc. When happy with the results, copy the cells with the formula then EditPaste Special(in place)ValuesOKEsc. Gord Dibben Excel MVP On Wed, 30 Mar 2005 14:41:01 -0800, TommyG wrote: Help tries to explain how to turn lower case to upper case but fails miserably! Can someone walk me through it? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Upper & Lower case problem in VBA | Excel Discussion (Misc queries) | |||
| Count the occurance of upper or lower case letters | Excel Worksheet Functions | |||
| How do I easily draw in Excel the Upper and Lower limits of a con. | Charts and Charting in Excel | |||
| Identifying the Active Fill Color | Excel Discussion (Misc queries) | |||
| change typed text to upper case | Excel Discussion (Misc queries) | |||
Linear Mode
