Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Change the text from lower case to upper case in an Excel work boo
How can I change the text from lower case to upper case in an Excel work book
and vice versa? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Change the text from lower case to upper case in an Excel work boo
To get the value in an other cell
=UPPER(A1) If you want to do a whole sheet, with VBA For each cell In Activesheet.UsedRange If Not cell.HasFormula Then cell.Value = UCase(Cell.Value) End If Next cell -- HTH Bob Phillips (remove nothere from email address if mailing direct) "dave01968" wrote in message ... How can I change the text from lower case to upper case in an Excel work book and vice versa? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Change the text from lower case to upper case in an Excel work boo
The lower case equivalents are LOWER and LCase.
-- HTH Bob Phillips (remove nothere from email address if mailing direct) "dave01968" wrote in message ... How can I change the text from lower case to upper case in an Excel work book and vice versa? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel should let me change case in the cell the text is in. | Excel Worksheet Functions | |||
convert value in word. For Exampe Rs.115.00 convert into word as . | Excel Discussion (Misc queries) | |||
How to convert entire excel document from lower to upper case | Excel Worksheet Functions | |||
Identifying the Active Fill Color | Excel Discussion (Misc queries) | |||
change typed text to upper case | Excel Discussion (Misc queries) |