Text Cut

Collapse
This topic is closed.
X
X
 
  • Time
  • Show
Clear All
new posts
  • kevcar40

    #1

    Text Cut

    Hi
    I have a string that varies in length ie ABCDEFGH or ABCDEFGHI
    what i want to do is read from the left 6 Characters and discard the
    leftleaving only the right of th string
    ie GH or GHI


    Thanks
    kevin

  • simon@geniecom.fsnet.co.uk

    #2
    Re: Text Cut

    Dim Str1,Str2
    str1 = "ABCDEFGH"
    str2 = Right(str1, Len(str1) - 6)
    msgbox str2


    This will take everything within the string, starting at character 7.

    Hope this helps

    Simon

    Comment

    • Lyle Fairfield

      #3
      Re: Text Cut

      YourString = Mid$(YourString , 7)

      Comment

      • kevcar40

        #4
        Re: Text Cut

        thank you both

        Comment

        Working...