troubleshooting Question

extract a substring between backslashes from paths

Avatar of Andreas Hermle
Andreas HermleFlag for Germany asked on
Microsoft OfficeMicrosoft ExcelVBA
10 Comments1 Solution70 ViewsLast Modified:
Dear Experts:

I would like to extract the 'PM_xx' substrings, i.e. PM_4, PM_6 and PM_2_3 from the below Paths, using a formula if possible

The links have one thing in common.
Looking from the right: these are the substrings between the first and second backslash.

C:\Users\DMD\PM_4\IFU_marSeal_5_steril_90-012-59-11_REV_1-2_RD_2015-07_6s_A4_S220.pdf
C:\Users\PM_6\IFU_maxium_5_steril_90-048-73-11_REV_7_RD_2015-07_6s_A4_S17.pdf
C:\Users\DMD\Files\PM_2_3\IFU_pincers_90-073-59-14_REV_2_RD_2015-07_6s_A4_S9.pdf

Help is much appreciated. Thank you very much in advance.

I have attached a sample file for your convenience.

Regards, Andreas

extract_substring.xlsx
ASKER CERTIFIED SOLUTION
Join our community to see this answer!
Unlock 1 Answer and 10 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 10 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros