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
|