Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
changing fonts in excel
is there a way to select a column and make the text all caps?
thanks in advance, |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
changing fonts in excel
No...but you can create a dummy column
=UPPER(A1) "bronxbabe" wrote: is there a way to select a column and make the text all caps? thanks in advance, |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
changing fonts in excel
Dear Bronxbabe
Create an additional blank column to the right or left of the column you want to convert. To convert first line of data (say A1), go to blank cell opposite to A1 in the column you have created. Use =upper(a1). Now you will see text of A1 in Caps. Copy this formula to the entire range below and all your column will be converted to Caps in another column. You can copy this entire column and then Paste Special on the original range (Paste Special as Values). If you don't need this additional column, you can delete it or retain it "bronxbabe" wrote: is there a way to select a column and make the text all caps? thanks in advance, |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
changing fonts in excel
Only if you use VBA, otherwise it has to be done on a cell by cell basis using a
helper column and the UPPER function. See other posts for how to use UPPER in a helper column. Gord Dibben MS Excel MVP On Tue, 5 Dec 2006 18:22:00 -0800, bronxbabe wrote: is there a way to select a column and make the text all caps? thanks in advance, |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
Changing a word document into an excel spreadsheet | Excel Discussion (Misc queries) | |||
fonts missing when using Insert Symbol in Excel | Excel Discussion (Misc queries) | |||
Changing the format of an Excel output file made by Microsoft Access | Excel Discussion (Misc queries) | |||
How do I stop excel automatically changing my date to 2005? | Excel Discussion (Misc queries) |