Remove text between "\" regardless of number of characters

Filename:

U:\Pjongyang\returns\Clients\0 Client Files Sorted\P - T\Gymkata\vReturn\2012\10_12\AWP\[Gymkata_AvaTax_Upload_Data_Summary_201210_vTEST.xls]qrySelUploadSummary

Formula:
=CONCATENATE(LEFT(MID(CELL("filename"),FIND("\",CELL("filename"))+54,LEN(CELL("filename"))),FIND("\",MID(CELL("filename"),FIND("\",CELL("filename"))+3,LEN(CELL("filename")))))," - ","11/2012")


Result:

Gymkata


I am trying to extract a company name from the file name. The company name is going to be different each time. What I wrote above works if the company name is the same length; I did not consider different counts in company names.

U:\Pjongyang\returns\Clients\0 Client Files Sorted\P - T\Gymkata\vReturn\2012\10_12\AWP\[Gymkata_AvaTax_Upload_Data_Summary_201210_vTEST.xls]qrySelUploadSummary


I now realize that what I really want is the text string between the 6th and 7th occurrence of "\". Can the formula I wrote be easily adapted to this change?

Nice, thank-you.

As I read it, the formula first replacing the 6th and 7th "\" with the "|". Do you use the | to make a unique character? Then the formula extracts everything between and including the pipes, the +1,-1 peel off the pipes. Do I have that correct?

A very good point, I will give that a try also.