Results 1 to 8 of 8
  1. #1
    Join Date
    Feb 2005
    Posts
    76

    Unanswered: retreive the middle of a string

    Im having a dumb moment... what is the easiest way to get the third and fourth character of a string???

    Thanks

  2. #2
    Join Date
    Feb 2004
    Location
    Poland
    Posts
    96
    RIGHT(LEFT ( col ,6 ),3)

  3. #3
    Join Date
    Jan 2007
    Location
    UK
    Posts
    11,434
    Provided Answers: 10
    Isn't there a MID string function in SS?

    MID(<yourString>, 3, 2)
    George
    Home | Blog

  4. #4
    Join Date
    Nov 2002
    Posts
    272
    Quote Originally Posted by georgev
    Isn't there a MID string function in SS?
    Yes, it's called SubString:

    SUBSTRING ( expression , start , length )

  5. #5
    Join Date
    Jan 2007
    Location
    UK
    Posts
    11,434
    Provided Answers: 10
    I thought I'd used something similar in QA before.
    Ta Ivon
    George
    Home | Blog

  6. #6
    Join Date
    Feb 2005
    Posts
    76
    Thank You

  7. #7
    Join Date
    Jan 2006
    Location
    USA
    Posts
    115
    Quote Originally Posted by georgev
    I thought I'd used something similar in QA before.
    Ta Ivon
    May be you have used it in MS Excel..
    Rajesh Patel

    Everybody says - mistake is the first step of success, but it's not true. The correction of the mistake is the first step of success.

  8. #8
    Join Date
    Jan 2007
    Location
    UK
    Posts
    11,434
    Provided Answers: 10
    I'm guessing Access/VBA
    I (very) rarely program in Excel, because...

    ...well it's crap
    George
    Home | Blog

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •