Return value in text string between "\"

[Bravo33]

I have had a troll through and cannot seam to find any answers to a resolution for thew below scenario.

I have multiple text strings with "" in varying locations.Generally up to 1000 rows of which there are text strings withing the "" that I wish to retain.

ENQUIRY-01-01-08-18\W_SC-Lightning Protection\drgs-Low Option\

ENQUIRY-03-08-08-18\E_SC-Composite Concrete Decking\Specification-Low Option\

ADDITIONAL INFO-03-14-08-18\L_SC Stairs -ADDITIONAL INFO-03\

I would like to generate either VBA or a Macro to leave only the text between specific ""
For example:
Row 1 Remove

ENQUIRY-01-01-08-18\

&

\drgs-Low Option\

leaving

W_SC-Lightning Protection

Row 2 Remove

ENQUIRY-03-08-08-18\

&

\Specification-Low Option\

leaving

 E_SC-Composite Concrete 
Decking

Row 3 Remove

ADDITIONAL INFO-03-14-08-18\

& the last

\

leaving

L_SC Stairs -ADDITIONAL INFO-03

I would like to have the ability to select specific rows or number of rows and determine the number of leading and trailing

\

for text to be removed.

Any help greatly appreciated.

 

[Peter_SSs]

I'm not exactly clear what you want (too many code boxes ) but as far as I can understand it, you could do this with a standard worksheet formula as shown in column B below, or you could use a user-defined vba function as shown in the code below and column C in the screen shot.
If neither of these is what you want, please give further explanation/examples (just include the original data and the expected results).

Function Part(s As String, AfterDelimNum As Long) As String
  Part = Split(s, "\")(AfterDelimNum)
End Function

Excel Workbook
	A	B	C
1	ENQUIRY-01-01-08-18\W_SC-Lightning Protection\drgs-Low Option\	W_SC-Lightning Protection	W_SC-Lightning Protection
2	ENQUIRY-03-08-08-18\E_SC-Composite Concrete Decking\Specification-Low Option\	E_SC-Composite Concrete Decking	E_SC-Composite Concrete Decking
3	ADDITIONAL INFO-03-14-08-18\L_SC Stairs -ADDITIONAL INFO-03\	L_SC Stairs -ADDITIONAL INFO-03	L_SC Stairs -ADDITIONAL INFO-03
Extract Text

 

[Bravo33]

I'm not exactly clear what you want (too many code boxes ) but as far as I can understand it, you could do this with a standard worksheet formula as shown in column B below, or you could use a user-defined vba function as shown in the code below and column C in the screen shot.
If neither of these is what you want, please give further explanation/examples (just include the original data and the expected results).

Function Part(s As String, AfterDelimNum As Long) As String
  Part = Split(s, "\")(AfterDelimNum)
End Function

Excel Workbook
	A	B	C
1	ENQUIRY-01-01-08-18\W_SC-Lightning Protection\drgs-Low Option\	W_SC-Lightning Protection	W_SC-Lightning Protection
2	ENQUIRY-03-08-08-18\E_SC-Composite Concrete Decking\Specification-Low Option\	E_SC-Composite Concrete Decking	E_SC-Composite Concrete Decking
3	ADDITIONAL INFO-03-14-08-18\L_SC Stairs -ADDITIONAL INFO-03\	L_SC Stairs -ADDITIONAL INFO-03	L_SC Stairs -ADDITIONAL INFO-03
Extract Text

Peter,
Many thanks for your swift response.
The formula is perfect.

You just saved me hours of work....Thanks!!

 

[Peter_SSs]

Peter,
Many thanks for your swift response.
The formula is perfect.

You just saved me hours of work....Thanks!!

You're welcome.