extracting text between 2 text strings

[SQUIDD]

Hi All

What is the best formula to get the number in red below, no matter what lenght the number may be.
Im confident the id= and the ">V will always be either side in green.

<tbody>
</tbody>

< a title="View Race" href="resultsRace.aspx?id=1942402">View Race
many thanks

Dave

 

[FDibbins]

Try this...
=LOOKUP(99^99,--("0"&MID(A1,MIN(SEARCH({0,1,2,3,4,5,6,7,8,9},A1&"0123456789")),ROW($1:$10000)))) Courtesy of:*Ron Coderre

 

[Joe4]

Looks like your last edit change the view of your data.
You originally had this:

id=1942402">View Race

If the value were in cell A1, this should get what you want:

=MID(A1,FIND("id=",A1)+3,FIND(">V",A1)-FIND("id=",A1)-4)

 

[AliGW]

Try this:

=LEFT(SUBSTITUTE(A1,"id=",""),FIND(">",SUBSTITUTE(A1,"id=",""))-2)

EDIT: this will not work with the amended request -sorry.

 

[SQUIDD]

dear all

sorry, it would not let me add the full string, but i think i have it now.

please see my edited post.

dave

 

[Joe4]

Both the formulas Ford and I posted seem to return what you are looking for.

 

[SQUIDD]

Thanks all

sorry for the confusion.
Joe, i used yours in the end.

thanks again all.

Dave

 

[AlKey]

Here is another way

=TRIM(MID(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A1,""">","|"),"id=","|"),"|",REPT(" ",99)),99,99))

Excel 2016 (Windows) 32 bit
	A	B
1	< a title="View Race" href="resultsRace.aspx?id=1942402">View Race	1942402
Sheet4