Quote Originally Posted by doofusboy
For sTemp = "05/24/06 16:00 -- Start working on #1"

If you wanted to use Split, this should return "Start":

VB Code:
  1. your_result = Split(Split(sTemp, "--")(1), " ")(1)
thanks, thats what I was looking for .. didnt knowi could use split like that .. cool thanks .

Rory