Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
normal into Capital letters automatically
Please help me to turn normal letters into CAPITALS automatically, in an
excel sheet. Thank you very much! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
normal into Capital letters automatically
Hello thalia
Not sure about what you want: How do I enter capital letters? - Activate CapsLock Key How do I convert all string values already entered? - Use a macro: Sub ChangeIntoCaps() Dim rg As Range For Each rg In Range("A1:B10") If Application.WorksheetFunction.IsText(rg) Then rg.Value = UCase(rg) End If End Sub HTH Cordially Pascal "thalia" a écrit dans le message de news: ... Please help me to turn normal letters into CAPITALS automatically, in an excel sheet. Thank you very much! |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
normal into Capital letters automatically
Hi
=UPPER(A1) will return the contents of A1 in Capitals =LOWER(A1) returns lower case =PROPER(A1) will capitalise the first letter .of each word -- Regards Roger Govier "thalia" wrote in message ... Please help me to turn normal letters into CAPITALS automatically, in an excel sheet. Thank you very much! |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
normal into Capital letters automatically
Oops sorry: one line is missing in the macro sample:
Sub ChangeIntoCaps() Dim rg As Range For Each rg In Range("A1:B10") If Application.WorksheetFunction.IsText(rg) Then rg.Value = UCase(rg) End If Next rg End Sub Apologies Cordially Pascal "papou" a écrit dans le message de news: ... Hello thalia Not sure about what you want: How do I enter capital letters? - Activate CapsLock Key How do I convert all string values already entered? - Use a macro: Sub ChangeIntoCaps() Dim rg As Range For Each rg In Range("A1:B10") If Application.WorksheetFunction.IsText(rg) Then rg.Value = UCase(rg) End If End Sub HTH Cordially Pascal "thalia" a écrit dans le message de news: ... Please help me to turn normal letters into CAPITALS automatically, in an excel sheet. Thank you very much! |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
normal into Capital letters automatically
You want it done as you enter the letters?
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 As written Works on column A:B only. This is event code. Right-click on the sheet tab and "View Code". Copy/paste the code into that sheet module. Gord Dibben MS Excel MVP On Thu, 11 Oct 2007 04:22:01 -0700, thalia wrote: Please help me to turn normal letters into CAPITALS automatically, in an excel sheet. Thank you very much! |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
normal into Capital letters automatically
hi, thalia !
Please help me to turn normal letters into CAPITALS automatically, in an excel sheet... if available, try to change the font for your range/worksheet/workbook/style/... this fonts shows text un uppercase: - Castellar - Engravers MT - Felix Titling - Stencil - Technic (*versalles* type) this font shows text in lowercase: - Chick (*condensed & bold* already) hth, hector. |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
normal into Capital letters automatically
hi (again), thalia !
please, disregard font for lowercase (my mistake) lowercase shows with fonts: - Freshbot - Poornut - Pussycat hth, hector. Please help me to turn normal letters into CAPITALS automatically, in an excel sheet... if available, try to change the font for your range/worksheet/workbook/style/... this fonts shows text un uppercase: - Castellar - Engravers MT - Felix Titling - Stencil - Technic (*versalles* type) this font shows text in lowercase: - Chick (*condensed & bold* already) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Replacing capital letters | Excel Discussion (Misc queries) | |||
how to change small letters to capital letters | Excel Discussion (Misc queries) | |||
how do i turn all letters into capital letters? | Excel Discussion (Misc queries) | |||
Capital Letters Only | Excel Discussion (Misc queries) | |||
Capital Letters | Excel Worksheet Functions |