Extra text after specific characters

[Country_Calc_2]

Hi,

I am looking for 2 formulas to extract text that could be anywhere within cell A1.

B1 will always start with 'NCT*" and be 11 characters.

C1 will always follow "EudraCT Number: *" and be 14 characters.

057-08 536/2010 AC-055-302/SERAPHIN EudraCT Number: 2007-002440-14 NCT00660179 NL20580.100.08 SERAPHIN

NCT00660179

2007-002440-14

I tried searching the board, but the examples I saw were alot more complex.

 

[Fluff]

How about

Fluff.xlsm
	A	B	C
1	057-08 536/2010 AC-055-302/SERAPHIN EudraCT Number: 2007-002440-14 NCT00660179 NL20580.100.08 SERAPHIN	NCT00660179	2007-002440-14
Sheet6

Cell Formulas
Range	Formula
B1	B1	=MID(A1,SEARCH("nct",A1),11)
C1	C1	=MID(A1,SEARCH("eudract",A1)+16,14)

 

[Jeffrey Mahoney]

How about this:

Book4
	A	B	C
1	057-08 536/2010 AC-055-302/SERAPHIN EudraCT Number: 2007-002440-14 NCT00660179 NL20580.100.08 SERAPHIN	NCT00660179	2007-002440-14
Sheet1

Cell Formulas
Range	Formula
B1	B1	=MID(A1,SEARCH("NCT",A1),11)
C1	C1	=MID(A1,SEARCH("EudraCT",A1)+16,14)

 

[Country_Calc_2]

Thanks Fluff and Jeffery, but I marked as the first solution as it was the same.

 

[Fluff]

Glad we could help & thanks for the feedback.