View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
tommcbrny tommcbrny is offline
external usenet poster
 
Posts: 57
Default Exclude all but last text to the right

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