Grabbing text between slashes in Excel

excel

Solution

This is by no means a 'clean' method of going about it; and would only apply to finding the first set of text.

=LEFT(RIGHT(B9, LEN(B9)-FIND("\",B9)),FIND("\",B9, FIND("\",B9)+1)-FIND("\",B9)-1)

Slightly cleaner form: =MID(B9, FIND("\",B9)+1, FIND("\",B9, FIND("\",B9)+1)-FIND("\",B9)-1)

Problem

I have an excel sheet and was trying to figure out if there was a way to grab text b/w slashes. For example: [In cell B9] R:\FINANCE-Asia\Q1Report.html I want to pull out: FINANCE-ASIA and place it into cell C9. Anybody know what the formula for this would be?

Original source