Splitting a String 1

[SgtPepps]

I have an 8 caracter string and I need to obtain the last three digits and create another variable from them. Could someone help me as i dont have enough time to get a book.

Kind Regards

SgtPepps

 

[SkipVought]

Hi sarg!

You want to use the Right function...

If Len(SourceString) > 3 Then 
   MyString = Right(SourceString, 3)
Else
   MyString = "TILT!"
End If

If SourceString is "ABCDEF" then MyString will be "DEF".

Hope this helps Skip,
metzgsk@voughtaircraft.com

 

[SgtPepps]

cool, cheers!!

SgtPepps

 

[xlbo]

Give it a star then - it's the right way to show recognition
Click on the "Click here to mark this post as a helpful or expert post"
G