If you have a column of these thing, then use Text to Columns. Pull-down:

Data Text to Columns... and follow the wizard. Use the / as the separator.

You will see:


--
Gary''s Student


"Richard Ruda" wrote:

We have a field of characters similar to:
product/small/GW1400A-GAVE.jpg
We have unsuccessfully tried to use the RIGHT AND FIND functions to
find all characters after the last "/" ( or from the right, all characters
before up to the first /). In other words to extract the GW1400A-9AV.jpg
Perhaps we are using the wrong functions.
Any assistance would be appreciated.
Richard