Find and grab a substring in Excel

[Sartanus]

Ok, quick question, I am attempting to find a chunk of text in a string and place that chunk into its own string.

So say I have
"This is my string"

and I want to grab "my" out of the bunch and stick it in another string.

This wouldn't be a prob... However, the string varies and sometimes "my" is not going to exist.

Any suggestions, I had thought at first just loop thru till " " was encountered then read first letter, see if its what I want, if not go to next word, etc...

Tho dunno how the heck to do this in VB(somewhat VB handicapped

Any quickie suggestions? Seems fairly easy, but I can't really think of a non sadistic way of taking it.

[Sartanus]

The string might also be "and so this my string" still want to get "my"

[InvisibleDuncan]

MsgBox InStr("This is my string", "my")

Returns 0 if it doesn't find it, otherwise returns the position at which it was found.