Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Hi, I want to return the words/ string of words after the last divider "/".
e.g. in Column A, there are Society/Education/University/USA Society/Education/University/USA/University of Chicago Family/babies Leisure/Outdoor/camping I want to return: USA University of Chicago babies camping in Column B. The number of "/" is variable in each row. I only know how to return the value after a specific count of "/", like: =mid(a1, search("/", A1, 2), Len(A1)) to return University/USA But I don't know how to return the value counting from the last "/". Can anyone help me? Thanks! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel search function | Excel Discussion (Misc queries) | |||
Custom functions calculating time arguments Help Desperate | Excel Worksheet Functions | |||
VLookup function to search an entire workbook | Excel Worksheet Functions | |||
a search function | Excel Worksheet Functions | |||
Search function | Excel Discussion (Misc queries) |