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

  • Thread starter modify email template
  • Start date
M

modify email template

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?
 
P

Peo Sjoblom

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
 
G

Gord Dibben

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
 
Top