View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ciarán Ciarán is offline
external usenet poster
 
Posts: 7
Default Extracting the last word from a string.

I have a list in excel like the one below.
The filename is always after the last "/".
What formula can I use to extract the filename?
The number of instances of "/" is not cosistent in every path string.


../ABCD/home/ABCD/EFGH/ciaran
../ABCD/home/ABCD/EFGH/bin/paul
../ABCD/home/james
../ABCD/home/ABCD/EFGH/bin/partition

The results I would like a
ciaran
paul
james
partition