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

thks

=UPPER(A1)


"Christine" wrote:

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

thks

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/E...e,_-70937.html

and many others, don't pay for code to do this!

--
Thanks,
Shane Devenshire


"Christine" wrote:

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

thks

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(xlCellTypeConst ants)
.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.

--
Rick (MVP - Excel)


"Christine" wrote in message
...
how can I convert all normal text to all CAP text?

thks

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.

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

Hi Hector

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

cheers

"Héctor Miguel" wrote:

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.