Give the characters after a searched string

[flaviooooo]

Hey,

Can this be done?

I have a string value, that contains a word that I'm looking for. Now I would like to return the 3 characters, that follow this word.

For example the string is "Cost Center: 123" and I would like to return the 123

How can I achieve this? I think there is a fairly simple way to do it, but I can't remember...

 

[Remou]

Some notes:

[tt]strSearch = "Cost Center: 123"
strFor = "Cost Center: "

Debug.Print Mid(strSearch, InStr(strSearch, strFor) + Len(strFor))[/tt]