[RESOLVED] Changing from ALLCAPS to CapOnlyForFirstLetter in Excel 2000 on WinXP
Results 1 to 4 of 4

Thread: [RESOLVED] Changing from ALLCAPS to CapOnlyForFirstLetter in Excel 2000 on WinXP

  1. January 8th, 2007, 10:41 AM #1
    OneBigNewbie
    OneBigNewbie is offline Virtual Intern
    Join Date
    Sep 2001
    Location
    Toronto, Ontario, Canada
    Posts
    216

    Resolved [RESOLVED] Changing from ALLCAPS to CapOnlyForFirstLetter in Excel 2000 on WinXP

    Hi,

    I have received an Excel spreadsheet with about 20,000+ rows x 6 columns, and in a few of the columns in the spreadsheets are names of people or companies, all in ALLCAPS (e.g. MICROSOFT CORPORATION, COMPUTER ASSOCIATES, INC., etc).

    I want to reformat them to "CapOnlyForFirstLetter", such as Microsoft Corporation, and Computer Associates, Inc., in the foregoing examples.

    Is there an easy way to do that. It'll save me a lot of re-keying (big waste of time) !

    Appreciate your help.
    Newbie
    Reply With Quote Reply With Quote
  2. January 8th, 2007, 10:54 AM #2
    Steve R Jones's Avatar
    Steve R Jones
    Steve R Jones is offline Administrator
    Join Date
    Sep 1999
    Location
    Clearwater, Fl.
    Posts
    22,610
    Excel doesn't have the ability.
    MS Word does...Format-> Change Case

    Maybe you can copy n paste back n forth.
    If you're happy and you know it......it's your meds.
    Reply With Quote Reply With Quote
  3. January 9th, 2007, 10:26 AM #3
    NickC
    NickC is offline Virtual PC Surgeon!
    Join Date
    Dec 2002
    Location
    Portland, OR, USA
    Posts
    1,457
    Excel 2003 can do this, though I'm not sure if Excel 2000 can. The formula is Proper. So if A1 says MICROSOFT CORPORATION, define B1 to be (without quotes)

    "=PROPER(A1)"

    You can also use the code UPPER and LOWER. PROPER means first letter in caps.
    My equipment:

    Acer Aspire AX3300-U1322 Desktop (sorry didn't build this time!), 4Gb RAM, AMD Athlon II quad core CPU
    Reply With Quote Reply With Quote
  4. January 9th, 2007, 03:21 PM #4
    OneBigNewbie
    OneBigNewbie is offline Virtual Intern
    Join Date
    Sep 2001
    Location
    Toronto, Ontario, Canada
    Posts
    216
    Thank you all for your advice, I copied the Excel book into Word, and then formated, and copied back into Excel. All the text effects I wanted are in Excel very successfully.
    Newbie
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules