+ Reply to Thread
Results 1 to 6 of 6

How do I change from all caps to proper case?

  1. #1
    Tom III
    Guest

    How do I change from all caps to proper case?

    I purchased a rather large list that is in all caps (in .txt format). Is
    there a function that will allow Excel (or any other Office product) to
    automatically change the names to proper case? I will need to save the
    results back in .txt format to import into a contact management program.

  2. #2
    JE McGimpsey
    Guest

    Re: How do I change from all caps to proper case?

    take a look here:

    http://www.mvps.org/dmcritchie/excel/proper.htm#proper

    In article <[email protected]>,
    "Tom III" <Tom [email protected]> wrote:

    > I purchased a rather large list that is in all caps (in .txt format). Is
    > there a function that will allow Excel (or any other Office product) to
    > automatically change the names to proper case? I will need to save the
    > results back in .txt format to import into a contact management program.


  3. #3
    Guest

    How do I change from all caps to proper case?

    =propoer(A1) in excel
    or open in Word andFormat>Change Case
    >-----Original Message-----
    >I purchased a rather large list that is in all caps

    (in .txt format). Is
    >there a function that will allow Excel (or any other

    Office product) to
    >automatically change the names to proper case? I will

    need to save the
    >results back in .txt format to import into a contact

    management program.
    >.
    >


  4. #4
    Britty
    Guest

    RE: How do I change from all caps to proper case?

    I have tried this and it doesn't seem to work.
    Where do I put the =proper(A1) ... in the column marked A1 or for the whole
    column?

    "[email protected]" wrote:

    > =propoer(A1) in excel
    > or open in Word andFormat>Change Case
    > >-----Original Message-----
    > >I purchased a rather large list that is in all caps

    > (in .txt format). Is
    > >there a function that will allow Excel (or any other

    > Office product) to
    > >automatically change the names to proper case? I will

    > need to save the
    > >results back in .txt format to import into a contact

    > management program.
    > >.
    > >

    >


  5. #5
    George Nicholson
    Guest

    Re: How do I change from all caps to proper case?

    - Make a backup!
    - Add a new column (lets say it's column B)
    - In B1 type: = Proper(A1)
    - B1 should now reflect how you want the data in A1 to appear
    - Copy B1 down as far as your list goes. Calculate (F9), if necessary.
    - Select Column B and Copy it.
    - With Column B still selected: Edit>PasteSpecial>Values (this replaces the
    formula with the formula results)
    - After verifying that Column B is what you want and has no loss of data,
    you can delete Column A

    HTH,
    --
    George Nicholson

    Remove 'Junk' from return address.


    "Britty" <[email protected]> wrote in message
    news:[email protected]...
    >I have tried this and it doesn't seem to work.
    > Where do I put the =proper(A1) ... in the column marked A1 or for the
    > whole
    > column?
    >
    > "[email protected]" wrote:
    >
    >> =propoer(A1) in excel
    >> or open in Word andFormat>Change Case
    >> >-----Original Message-----
    >> >I purchased a rather large list that is in all caps

    >> (in .txt format). Is
    >> >there a function that will allow Excel (or any other

    >> Office product) to
    >> >automatically change the names to proper case? I will

    >> need to save the
    >> >results back in .txt format to import into a contact

    >> management program.
    >> >.
    >> >

    >>




  6. #6
    JustinLabenne
    Guest

    Re: How do I change from all caps to proper case?


    Ivan Moala has a "Case Change" utility available that works very nice
    here:

    http://www.xcelfiles.com/Downloads_01.html

    Also ASAP Utilities has an option available for for case changing
    here:

    http://www.asap-utilities.com/

    Nothing to do on your part except download the "free" add-in, save it
    in your library path, then let the utility do the work.

    Then just copy / paste back to .txt format, or whatever is needed. If
    this is a procedure you do often, these add-ins are a real time saver
    when it comes to changing to Proper/Lower/All Caps


    --
    JustinLabenne

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1