I would copy the column then DataText to ColumnsDelimited by "/"

Then in third step pick the items to skip(do not import) and you would be left
with what you want.


Gord Dibben MS Excel MVP

On Fri, 15 Dec 2006 08:23:00 -0800, tommcbrny
wrote:

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