ALL CAPS FONT

[Guest]

Id there a font in Excel that will caps everything or is there a way I can do that..I exported some things feom Access to Exel and it put in lower case...?

 

[W L]

In excel u can use the UPPER function to convert a lowercase string of text
to uppercase. Assuming your text is in cell A1, u could type =UPPER(A1) in
an adjoining cell.

Id there a font in Excel that will caps everything or is there a way I can

do that..I exported some things feom Access to Exel and it put in lower
case...?

 

[Jonathan Rynd]

Id there a font in Excel that will caps everything or is there a way I
can do that..I exported some things feom Access to Exel and it put in
lower case...?

If your cell is A1, put the following in another cell:
=UPPER(A1)

and put similar formulas into other cells.

 

[David McRitchie]

Better to use a macro, but converting everything to upper case is
going to probably make for a difficult to work with spreadsheet.

You might take a look at
Proper, and other Text changes -- Use of SpecialCells
http://www.mvps.org/dmcritchie/excel/proper.htm

As far as font goes, that would not change the content, and there aren't
many fonts that would display all letters as capitals and you probably
would not want to use them anyway. But if you select font and then
use the arrow key to go down through them you will see some
ALGERIAN
BERMUDA SOLID
CASTELLER
If you don't see the name of the font in it's own font, there is an option
Tools (menu), Customize(menu), Options (tab), [x] List Font names in their font


HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

Id there a font in Excel that will caps everything or is there a way I can do that..I exported some things feom Access to Exel and

it put in lower case...?