Results 1 to 8 of 8

(SOLVED) Change ALL CAPS words from in string into Title Case

Threaded View

  1. #1
    Registered User
    Join Date
    11-21-2011
    Location
    boston, ma
    MS-Off Ver
    Excel 2007
    Posts
    25

    Question (SOLVED) Change ALL CAPS words from in string into Title Case

    I've been working on a major project and I'm almost there. Thanks for anyone on the forum who has helped!

    This is a case question which no Proper function or anything has been able to solve.

    I have strings of of 1+ sentences with some words being in ALL CAPS, and others in Title caps. I want to turn the words in all caps into title caps.

    Example: The lazy Fox Jumped OVER the fence.
    Output: The lazy Fox Jumped Over the fence.

    I've browsed and have been unable to find anything so far. Thanks in advance.
    Last edited by agf12555; 12-22-2011 at 11:20 AM. Reason: solved

Thread Information

Users Browsing this Thread

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

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1