Quote Originally Posted by RobDog888
You could use instrrev instead so you start your search for the dash from the end (right side to left side) and catch the last occurance of the dash.
VB Code:
  1. 'something like this...

  2. intPos = InStrRev(strBuff, "-") + 1
So, do I replace all my IntStr to InStrRev ?