+ Reply to Thread
Results 1 to 3 of 3

Forces all text to Proper case

  1. 02-22-2015, 08:21 PM #1
    zplugger
    zplugger is offline
    Forum Contributor
    Join Date
    03-05-2009
    Location
    usa
    MS-Off Ver
    Excel 2016 32Bit
    Posts
    1,173

    Forces all text to Proper case

    Can this be done with VBA, want first letter in every word in cell A1 to be Capital
    Thanks
    Last edited by zplugger; 02-22-2015 at 08:28 PM.
    Reply With QuoteRegister To Reply
  2. 02-22-2015, 08:23 PM #2
    berlan
    berlan is offline
    Forum Expert
    Join Date
    02-22-2013
    Location
    London, UK
    MS-Off Ver
    Office 365
    Posts
    1,218

    Re: Forces all text to Proper case

    Try:
    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  3. 02-22-2015, 08:27 PM #3
    zplugger
    zplugger is offline
    Forum Contributor
    Join Date
    03-05-2009
    Location
    usa
    MS-Off Ver
    Excel 2016 32Bit
    Posts
    1,173

    Re: Forces all text to Proper case

    You just amaze me berlan, you are a walking code book. Thanks
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] To have proper case in certain cells if there is text in it
    By nenadmail in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-07-2012, 05:11 PM
  2. Using VBA to convert text to proper case
    By Darlo in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-26-2007, 05:59 PM
  3. Converting CAPS text to Proper Case
    By rsantos17 in forum Excel General
    Replies: 1
    Last Post: 05-04-2006, 12:40 PM
  4. Macro for changing text to Proper Case
    By JPriest in forum Excel Formulas & Functions
    Replies: 35
    Last Post: 09-06-2005, 07:05 PM
  5. Correct Text Case to PROPER capitalization
    By halljlsampeck in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-15-2005, 06:45 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1