Results 1 to 5 of 5

Thread: Excel and capitalization

  1. #1
    Join Date
    Jul 2006
    Posts
    286

    Excel and capitalization

    Hello,
    I wonder if it is possible in Excel simply switch a cell containing text in lowercase text to uppercase (in something like Word with the Shift + F3). I know that you can not ask a spreadsheet to have all the features of a word processing. Is there any way I can set a column to have the first letter of each word capitalized no matter how the user types it?

    Thank you
    IF you hate me, please don't mention it. I know who hates me and who doesn't. You really do not have to make fun of people....

  2. #2
    Join Date
    May 2008
    Posts
    4,570

    Re: Excel and capitalization

    hello
    Your Microsoft Office program can make your work easier by automatically correcting capitalization errors. The default options usually work well for most people, so you may not need to modify these options. However, if it is necessary, you can easily customize the automatic capitalization options. for more details see this

    1. Click the Microsoft Office ButtonButton image, and then click Excel Options at the bottom of the window.
    2. Click Proofing.
    3. Click the AutoCorrect Options button.
    4. On the AutoCorrect tab, select or clear any of the following check boxes:

    • Correct TWo INitial CApitals
    • Capitalize first letter of sentences
    • Capitalize names of days
    • Correct accidental use of cAPS LOCK key

  3. #3
    Join Date
    Apr 2008
    Posts
    4,642

    Re: Excel and capitalization

    You can have another column which has =PROPER(A1), but that's not quite what you want. You need an event macro. Right-click the sheet tab, select View Code, enter this, which applies to column C (3): -- change the colulmn accordingly.

    Code:
    Private Sub Worksheet_Change(ByVal Target As Range)
       If Target.Column = 3 Then
           Application.EnableEvents = False
           Target.Resize(1, 1).Value = Application.Proper(Target.Value)
           Application.EnableEvents = True
       End If
    End Sub

  4. #4
    Join Date
    Jul 2006
    Posts
    286

    Re: Excel and capitalization

    Hello,

    Thank you for those explanations, it works well. By against, is there a way to cancel the execution of Macro, unless I Executive step in the right cell ?

    Thank you
    IF you hate me, please don't mention it. I know who hates me and who doesn't. You really do not have to make fun of people....

  5. #5
    Join Date
    Jan 2012
    Posts
    2

    smile Re: Excel and capitalization

    Hello,

    I joined this forum just to answer your question!

    I just encountered the same problem at work and there is a much easier and quicker way!!

    1. Click on a blank cell.
    2. Type this text: =UPPER
    3. Click on the first cell in the column that you want to change to upper case.
    4. Drag the corner of the blue box that appears so that it has all the cells you want changed, inside.
    5. Go to the formular bar with the equation and add a bracket to the end.
    6. The formular should look something like this: =UPPER(E2:E13)
    7. Press enter.
    8. All the text will now be in the blank columns/cells. If not, drag the corner of the black box and drag down, and the rest of the data will appear).
    9. Copy all the new data. Right click on the first cell to be replaced and click, 'paste special' and then click 'values'.
    10. Paste this data over the top of the original lower case data.
    http://support.microsoft.com/kb/263580

    Hope this helps!

    Mandy

Similar Threads

  1. Replies: 4
    Last Post: 02-11-2012, 12:36 AM
  2. Replies: 2
    Last Post: 18-02-2012, 03:34 AM
  3. Excel 2007 file fails to get permission to open in Excel 2011
    By Raju Chacha in forum Windows Software
    Replies: 6
    Last Post: 13-01-2012, 09:17 PM
  4. Replies: 6
    Last Post: 25-07-2009, 12:01 AM
  5. Excel: format data capitalization
    By AdityaR in forum Windows Software
    Replies: 3
    Last Post: 11-06-2009, 07:09 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Page generated in 1,711,675,846.65756 seconds with 17 queries