Hi Tommy

Try
=MID(A1,FIND(" ",SUBSTITUTE(A1,"/"," ",3))+1,255)
and copy down
--
Regards

Roger Govier


"tommcbrny" wrote in message
...
Hello,

I have a column that lists project, sub-project, sub-project, area and
would
like the cells in this column to display only the area for a report I
am
creating.

For example, cells in the column contain:
/XYZ/ABCD/New Requests
/XYZ/ABCD/Problems
/XYZ/ABCD/Features

But I only want the information beyond the last slash, for example:
New Requests
Problems
Features

Is there a function that will do this?

Thank you,
Tom