How do I make all caps in a column of any spreadsheet?
 

I need to enter a formula so a specific column on my spreadsheet will haave
all CAPS. I need step-by-step to enter this formula. Can anyone help?

You can't change to all caps with a formula, you can use a help column where
you put the formula, assume that A1:A200 are the values you want to have in
caps, if B1 is not empty select B and insert a new column, then in B1 put

=UPPER(A1), copy down 200 rows, select and copy then paste special as
values, finally delete column A and the help column will be A

Otherwise you have to use a macro

http://www.mvps.org/dmcritchie/excel/proper.htm

scroll down until you see Uppercase





Regards,

Peo Sjoblom

"modify email template" wrote:

I need to enter a formula so a specific column on my spreadsheet will haave
all CAPS. I need step-by-step to enter this formula. Can anyone help?

If you want the text in CAPS as you type it.

Use worksheet event code that changes typed text to CAPS as you enter it.

Private Sub Worksheet_Change(ByVal Target As Excel.Range)
If Target.Column < 2 Then Exit Sub
On Error GoTo ErrHandler
Application.EnableEvents = False
Target.Formula = UCase(Target.Formula)
ErrHandler:
Application.EnableEvents = True
End Sub

This code operates on Column B(2). Change the (2) to suit.


Gord Dibben Excel MVP

On Wed, 11 May 2005 11:54:05 -0700, "Peo Sjoblom"
wrote:

You can't change to all caps with a formula, you can use a help column where
you put the formula, assume that A1:A200 are the values you want to have in
caps, if B1 is not empty select B and insert a new column, then in B1 put

=UPPER(A1), copy down 200 rows, select and copy then paste special as
values, finally delete column A and the help column will be A

Otherwise you have to use a macro

http://www.mvps.org/dmcritchie/excel/proper.htm

scroll down until you see Uppercase





Regards,

Peo Sjoblom

"modify email template" wrote:

I need to enter a formula so a specific column on my spreadsheet will haave
all CAPS. I need step-by-step to enter this formula. Can anyone help?