+ Reply to Thread
Results 1 to 4 of 4

ucase to exact case

  1. #1
    Registered User
    Join Date
    12-13-2011
    Location
    farmington MI
    MS-Off Ver
    Excel 2003
    Posts
    81

    ucase to exact case

    Hello all

    I have copied a code from online to do some of my cad stuff. Code does change every character to upper case because of this line

    Please Login or Register  to view this content.
    but I want exact return. Example ABCDefgh must return ABCDefgh. So I did the below but does not work

    Please Login or Register  to view this content.
    anyhelp much appriciated

    thanks
    var

  2. #2
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2010, 2019
    Posts
    40,689

    Re: ucase to exact case

    Your code snippet is correct.
    Entia non sunt multiplicanda sine necessitate

  3. #3
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,644

    Re: ucase to exact case

    var

    This is only going to give you one character from the string str1.
    Please Login or Register  to view this content.
    Do you have other code?

    If you already have ABCDefgh then you don't need to do anything to it.

  4. #4
    Registered User
    Join Date
    12-13-2011
    Location
    farmington MI
    MS-Off Ver
    Excel 2003
    Posts
    81

    Re: ucase to exact case

    my snippet worked in my home system..thanks guys

    var

+ 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