Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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? |
#2
|
|||
|
|||
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? |
#3
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
time differences in a column | Excel Worksheet Functions | |||
how to make column titles float with the scroll bar | Excel Discussion (Misc queries) | |||
Work with list to make 3rd column | Excel Worksheet Functions | |||
How do I make an entire column do the same calculation across a r. | Excel Discussion (Misc queries) | |||
Formula for a column | Excel Discussion (Misc queries) |