Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default normal into Capital letters automatically

Please help me to turn normal letters into CAPITALS automatically, in an
excel sheet. Thank you very much!
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 112
Default 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   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 2,480
Default 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   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 112
Default 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   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 22,906
Default 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   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 434
Default 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   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 434
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Replacing capital letters jezzica85 Excel Discussion (Misc queries) 5 February 23rd 10 07:49 AM
how to change small letters to capital letters HOW TO CHANGE Excel Discussion (Misc queries) 4 May 30th 07 01:12 AM
how do i turn all letters into capital letters? KeithT Excel Discussion (Misc queries) 3 May 11th 07 02:13 PM
Capital Letters Only Simon Jefford Excel Discussion (Misc queries) 2 February 2nd 06 07:04 PM
Capital Letters Gaute Excel Worksheet Functions 4 March 9th 05 10:55 AM


All times are GMT +1. The time now is 11:13 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"