Extracting the last word from a string.

C

Ciarán

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 are:
ciaran
paul
james
partition
 
M

Mike H

Hi,

Try this

=RIGHT(A1,LEN(A1)-FIND("*",SUBSTITUTE(A1,"/","*",LEN(A1)-LEN(SUBSTITUTE(A1,"/","")))))
--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

isolating a string containing a % symbol 5
get characters from a string in excel 2
Extracting data from different positions of a string 2
Extracting a numbers from a text string 24
extracting LAST x characters of a string 1
The last word 12
Extracting the last set of words from a text string 14
Extracting certain text from text string 2

Top