Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Text entries behaving like numbers | Excel Discussion (Misc queries) | |||
Aligning Wraped Text to the bottom of a cell | Excel Discussion (Misc queries) | |||
Conversion to Text file format error | Excel Discussion (Misc queries) | |||
How change dimensions of data label text box in pie chart? | Charts and Charting in Excel | |||
Read Text File into Excel Using VBA | Excel Discussion (Misc queries) |