Results 1 to 8 of 8

Help needed with a formula to convert upper-case words only to lower-case

Threaded View

  1. #1
    Registered User
    Join Date
    11-13-2009
    Location
    France
    MS-Off Ver
    Excel 2007
    Posts
    32

    Help needed with a formula to convert upper-case words only to lower-case

    Hi,

    Can you think of a formula that will convert upper-case words longer than three letters, into lower-case. Leaving the rest of the string unchanged?

    For example,

    Mary and John at IBM thought this was a GREAT OPPORTUNITY. Becomes:
    Mary and John at IBM thought this was a great opportunity.

    I have also tried using morefunc's REGEX.SUBSTITUTE but I couldn't get that to work either!

    Any ideas or help would be appreciated, thanks,

    Chris
    Last edited by holmwood; 04-18-2014 at 09:06 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Convert 1st letter of word to Upper Case and rest to lower case
    By rizmomin in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 05-23-2013, 11:44 AM
  2. [SOLVED] Trying to convert lower to upper case
    By Allgermanparts in forum Excel General
    Replies: 2
    Last Post: 07-02-2012, 05:07 AM
  3. [SOLVED] Convert lower case charecters to upper case
    By Dinesh in forum Excel General
    Replies: 3
    Last Post: 09-10-2005, 08:05 AM
  4. Convert UPPER CASE to Lower Case?
    By Newbie in forum Excel General
    Replies: 6
    Last Post: 07-21-2005, 06:05 AM
  5. [SOLVED] How do I convert all upper case excel sheet into upper and lower .
    By DebDay in forum Excel General
    Replies: 1
    Last Post: 03-09-2005, 05:06 PM

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