extract everything to the right of a character in string

[luv2glyd]

I have the following string: "string portion 1: string portion 2"

The string to the left and right of ":" varies in length and variety of characters used, but the ":" symbol is always there. How do I extract everything to the right of ":" and assign it to a VBA variable?

There's probably a way to do it with a formula, but I only need a VBA solution.

Thank you

[jindon]

a few ways

Please Login or Register  to view this content.

[luv2glyd]

Great! Thank you.