G
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...?
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.
W
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.
case...?
to uppercase. Assuming your text is in cell A1, u could type =UPPER(A1) in
an adjoining cell.
do that..I exported some things feom Access to Exel and it put in lowerBean said:Id there a font in Excel that will caps everything or is there a way I can
case...?
J
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.
D
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
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
it put in lower case...?Bean said: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