Extracting string between two specific delimiters among many of the same character.

I have a database that is the document control for many drawing numbers. What I would like to be able to do is extract just a portion of the drawing number that is between two delimiters ("-") but there are multiple of the same delimiters in the drawing name. For examples, I would like only the bold text to be the string that is extracted:

1_DC-1446-AH-POW.001
2_N2-2356-G-POW.001
2_N2-2356-G-POW.002
2_SC-4128-UFWC-POW.001

I would just do an =Right( formula, but as you can see from the examples, the string I am trying to return isn't always the same number of characters.

Any help on this will save me a world of time and be GREATLY appreciated.


-Separate Issue-
If anyone could also help me with a formula to isolate just the number(s) before the "_" character, that would help too! Sometimes this number is double digits.

Try this...

Data Range

	A	B	C
1	1_DC-1446-AH-POW.001	AH	1
2	2_N2-2356-G-POW.001	G	2
3	2_N2-2356-G-POW.002	G	2
4	2_SC-4128-UFWC-POW.001	UFWC	2
5	------	------	------

This formula entered in B1:

=TRIM(MID(SUBSTITUTE(A1,"-",REPT(" ",100)),200,100))

This formula entered in C1:

=--LEFT(A1,FIND("_",A1)-1)

Select B1:C1 and copy down as needed.

Hi and welcome to the forum.

Assuming the text required is always between the 2nd & 3rd - signs then

Formula:

Please Login or Register  to view this content.

You're welcome. Thanks for the feedback!

Here is with one formula
Enter in B1 and copy across and down

Formula:

Please Login or Register  to view this content.

v	A	B	C
1	1_DC-1446-AH-POW.001	1	AH
2	2_N2-2356-G-POW.001	2	G
3	2_N2-2356-G-POW.002	2	G
4	2_SC-4128-UFWC-POW.001	2	UFWC

Hi,

Just noticed a simpler solution if the required string always starts in the 11th position.

Formula:

Please Login or Register  to view this content.