Hi all, I have a question..

Lets say I have a String which is called (String1).

charlen = Len(String1)
and c2 = 250 (how many chars i want to show from the String1)

I want it that If String1 is bigger than 250 to show the final word as complete like this:

welcome to my website

NOT

welcome to my webs (where s is the 250 character)...

I used this but it didn't work with me


Code:
	IF charlen > c2 Then
		For i = c2 To charlen
			IF Mid(String1, i, 1) = " " Then
				c2 = i
				EXIT For
			End IF
		NEXT
	End IF