C
Christine
how can I convert all normal text to all CAP text?
thks
thks
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
T
Teethless mama
=UPPER(A1)
S
ShaneDevenshire
Hi,
=UPPER(A1) works on a cell by cell basis, if you want to do a large range
there are a number of utilities to do this in Excel.
There is free code at this site:
http://www.ozgrid.com/VBA/change-case-text.htm
or a free download here
http://www.freesharewarecenter.com/Excel_change_case_in_multiple_cells_to_uppercase,_-70937.html
and many others, don't pay for code to do this!
=UPPER(A1) works on a cell by cell basis, if you want to do a large range
there are a number of utilities to do this in Excel.
There is free code at this site:
http://www.ozgrid.com/VBA/change-case-text.htm
or a free download here
http://www.freesharewarecenter.com/Excel_change_case_in_multiple_cells_to_uppercase,_-70937.html
and many others, don't pay for code to do this!
R
Rick Rothstein
Press Alt+F11 to go to the VBA editor, click Insert/Module from its menu bar
and then copy/paste this macro into the code window that appeared...
Sub UpperCaseText()
With ActiveSheet.UsedRange.SpecialCells(xlCellTypeConstants)
.Formula = UCase(.Formula)
End With
End Sub
Now, go to the worksheet you want to capitalize the text on, press Alt+F8 to
bring up the macro dialog box, select UpperCaseText from the list and then
click the Run button. If there are other worksheets you want to do this on,
activate the worksheet and then repeat the instructions from previous
sentence.
and then copy/paste this macro into the code window that appeared...
Sub UpperCaseText()
With ActiveSheet.UsedRange.SpecialCells(xlCellTypeConstants)
.Formula = UCase(.Formula)
End With
End Sub
Now, go to the worksheet you want to capitalize the text on, press Alt+F8 to
bring up the macro dialog box, select UpperCaseText from the list and then
click the Run button. If there are other worksheets you want to do this on,
activate the worksheet and then repeat the instructions from previous
sentence.
H
Héctor Miguel
hi, Christine !
you might want to give a try to the following:
if available, try to change the font for your range/worksheet/workbook/style/...
(no other tricks/code/stuff/... needed) no matter if user types in lower/upper case...
this fonts shows text un uppercase:
- Castellar
- Engravers MT
- Felix Titling
- Stencil
- Technic (*versalles* type)
this font shows text in lowercase:
- Freshbot
- Poornut
- Pussycat
hth,
hector.
how can I convert all normal text to all CAP text?
you might want to give a try to the following:
if available, try to change the font for your range/worksheet/workbook/style/...
(no other tricks/code/stuff/... needed) no matter if user types in lower/upper case...
this fonts shows text un uppercase:
- Castellar
- Engravers MT
- Felix Titling
- Stencil
- Technic (*versalles* type)
this font shows text in lowercase:
- Freshbot
- Poornut
- Pussycat
hth,
hector.
F
franciz
Hi Hector
this is great! no formula or other stuff...
cheers
this is great! no formula or other stuff...
cheers