+ Reply to Thread
Results 1 to 5 of 5

Code to change text to lower case

  1. 10-16-2017, 02:20 PM #1
    rhudgins
    rhudgins is offline
    Forum Contributor
    Join Date
    01-05-2010
    Location
    New York
    MS-Off Ver
    Excel 2016
    Posts
    747

    Code to change text to lower case

    The following code consolidates data into column O-S. Current the text in column Q is all upper case. Can I change the code to make text in column Q all lower case?

    Please Login or Register  to view this content.
    Attached Files Attached Files
    Last edited by rhudgins; 10-16-2017 at 03:06 PM.
    Reply With QuoteRegister To Reply
  2. 10-16-2017, 02:47 PM #2
    6StringJazzer
    6StringJazzer is offline
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,747

    Re: Code to change text to lower case

    This code will change all data in column Q to lowercase.

    Please Login or Register  to view this content.
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]
    Reply With QuoteRegister To Reply
  3. 10-16-2017, 02:47 PM #3
    davesexcel
    davesexcel is offline
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,485

    Re: Code to change text to lower case 

    Please Login or Register  to view this content.
    ,
    Xlorate.com, Selection Codes, YouYube Channel
    Reply With QuoteRegister To Reply
  4. 10-16-2017, 02:51 PM #4
    mehmetcik
    mehmetcik is offline
    Forum Expert
    Join Date
    12-14-2012
    Location
    London England
    MS-Off Ver
    MS 365 Office Suite.
    Posts
    8,448

    Re: Code to change text to lower case

    Assuming Column R is empty

    Please Login or Register  to view this content.
    My General Rules if you want my help. Not aimed at any person in particular:

    1. Please Make Requests not demands, none of us get paid here.

    2. Check back on your post regularly. I will not return to a post after 4 days.
    If it is not important to you then it definitely is not important to me.
    Reply With QuoteRegister To Reply
  5. 10-16-2017, 03:06 PM #5
    rhudgins
    rhudgins is offline
    Forum Contributor
    Join Date
    01-05-2010
    Location
    New York
    MS-Off Ver
    Excel 2016
    Posts
    747

    Re: Code to change text to lower case

    Thank you all for the suggestions!
    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. Need to extract UPPER CASE text from the right until it find lower case or number
    By tawey123 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 07-14-2016, 05:51 AM
  2. [SOLVED] VB Code to convert text into Upper-Lower Case
    By rizmomin in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 05-19-2015, 01:00 AM
  3. how to change Lower case to capital case in same cell
    By sellva2205 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-21-2012, 11:52 AM
  4. Change lower case letters to upper case
    By SkeeterDon in forum Excel General
    Replies: 2
    Last Post: 10-28-2010, 11:05 AM
  5. change lower-case to upper-case
    By cutyfurby in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-17-2006, 11:15 AM
  6. Change the text from lower case to upper case in an Excel work boo
    By dave01968 in forum Excel General
    Replies: 2
    Last Post: 12-09-2005, 05:15 AM
  7. How do I change a column in Excel from upper case to lower case?
    By Debbie Kennedy in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-02-2005, 02: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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1