Formula to extract 5 or 6 digits based on the text

[shre0047]

I have a column with similar cells but spacing around the colon varies.

[TABLE="width: 500"]
<tbody>[TR]
[TD]ID1: 52685
ID2: 83145
ID3: 52973
ID4: 84814
Name: Kevin [/TD]
[/TR]
</tbody>[/TABLE]


FOr one formula, I want to find ID1, then extract the number 52685 which I have the following:
=MID($A2,MIN(FIND({0,1,2,3,4,5,6,7,8,9},$A2&"0123456789")),5)
How do I conduct it if it's 6 characters?

The other formula, I want to find ID4, and extract number 84814

 

[DanteAmor]

I'm glad to help you. Thanks for the feedback.

 

[jtakw]

You're welcome, thanks for the feedback.