Substring based on position in string

I'm trying to figure out a way to cut a particular substring out of a string, based on the start and end points of the substring.

For instance, I have code right now that will take in this example string:

"abcde + 1234 abcde"

And return two variables: a = 7 and b = 14. My variable a corresponds to finding the plus, and b corresponds to the first letter following the numbers.

My aim is to write a function to read in that string, and return "+ 1234", based on knowing a and b.

The only functions I know of with respect to strings are Mid, Len, Right/Left, and InStr, but none of them seem to read in a start and end point for substring finding. Right/Left would probably work, but I don't know how to cut the string from the right or the left using those.

Thanks guys.

Mid will work, try this.

Please Login or Register  to view this content.

Ah, mpeplow that was a good example! I changed it to

Please Login or Register  to view this content.

Which works like a charm!