View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Landa Landa is offline
external usenet poster
 
Posts: 15
Default Search / Mid function

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!