+ Reply to Thread
Results 1 to 4 of 4

ucase to exact case

Hybrid View

  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

    
    char1=ucase(mid(str1,i,1))   '(its in loop and str1 is my entry. I do not understand what 1 is for)
    but I want exact return. Example ABCDefgh must return ABCDefgh. So I did the below but does not work

    
    char1=mid(str1,i,1)
    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.
    char1=mid(str1,i,1)
    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