How to convert all words to CAPS

[Christine]

how can I convert all normal text to all CAP text?

thks

 

[Teethless mama]

=UPPER(A1)

 

[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!

 

[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.

 

[Héctor Miguel]

hi, Christine !

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.

 

[Dave Curtis]

Hi,

If your normal text is in A1, try using =UPPER(A1)

Or consider using Data Validation, Custom to force entry in Uppercase only.
=EXACT(A1,UPPER(A1))

Dave

url:http://www.ureader.com/msg/104241298.aspx

 

[franciz]

Hi Hector

this is great! no formula or other stuff...

cheers