Team leader

Andreas Hermle

<div>
Hi Neeraj, <br />
<br />
great, works like a charm, very professional, I highly appreciate it. <br />
<br />
Regards, Andreas
</div>


<div>
You're welcome Andreas! Glad it worked as desired. <br />
Thanks for the feedback.
</div>


<div>
<div class="content wysiwyg-content">
Dear Experts: <br />
<br />
I would like to extract string between first and second back slash from the RIGHT using a formula (bolded string)<br />
<br />
Any idea how I can achieve this? The string to be extracted always starts with PM_<br />
<br />
Help is much appreciated. Thank you very much in advance. <br />
<br />
Regards, Andreras<br />
<br />
\\172.20.10.68\DATEN$\KLS_<wbr />Allgemein\<wbr />NEW\Lot2\D<wbr />MD\<b>PM_4</b>\Sample_File_2_bw.pdf<br />
\\172.20.10.68\DATEN$\KLS_<wbr />Allgemein\<wbr />DMD\<b>PM_2_3</b>\Sample_File_4_bw_new_2.pd<wbr />f
</div>
</div>


Dear Experts: 

I would like to extract string between first and second back slash from the RIGHT using a formula (bolded string)

Any idea how I can achieve this? The string to be extracted always starts with PM_

Help is much appreciated. Thank you very much in advance. 

Regards, Andreras

\\172.20.10.68\DATEN$\KLS_Allgemein\NEW\Lot2\DMD\PM_4\Sample_File_2_bw.pdf
\\172.20.10.68\DATEN$\KLS_Allgemein\DMD\PM_2_3\Sample_File_4_bw_new_2.pdf

extract a substring between the first and second backslash from the right

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.

Microsoft Excel

Microsoft Office is an integrated suite of applications that includes Outlook, Word, Excel, Access, PowerPoint, Visio and InfoPath, along with a number of tools to assist in making the individual components work together. Coding within and between the projects is done in Visual Basic for Applications, known as VBA.