Hi all,

I want tot be able to capture a string value in Excel based on a wildcard. On this occasion the wildcard is a backslash. Here are some examples:

The\cat\sat\on\the\mat
The\cat\did not sit on the mat
c:\program files\mysoftware\my super software

I want to be able to capture the end of the string after the last backslash. In these examples the three values I would have returned is:

mat
did not sit on the mat
my super software

As the return value varies in length as well as the number of possible backslahes in the string it is a little more complicated than simply using the Excel "right" function. Can anyone help please.

Thanks.