changing fonts in excel
 

is there a way to select a column and make the text all caps?

thanks in advance,

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,

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,

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,