Extracting numbers

[kumar1803]

Hello,

Please help me build a formula for extracting the number from text below:

[TABLE="width: 391"]
<tbody>[TR]
[TD][/TD]
[/TR]
[TR]
[TD]IHB_PO :U100/0000102029/2017

I just need to extract 102029 from above.

Regards

Sunil[/TD]
[/TR]
</tbody><colgroup><col></colgroup>[/TABLE]

 

[JoeMo]

Assuming all your strings have the same format as shown in your OP:

Excel Workbook
	A	B
1	IHB_PO :U100/0000102029/2017	102029
Sheet1

 

[Rick Rothstein]

Please help me build a formula for extracting the number from text below:

[TABLE="width: 391"]
<tbody>[TR]
[TD][/TD]
[/TR]
[TR]
[TD]IHB_PO :U100/0000102029/2017

I just need to extract 102029 from above.
[/TD]
[/TR]
</tbody><colgroup><col></colgroup>[/TABLE]

If you beginning is always shaped the same (6 characters, as space, a colon and a three digit number, then this should work...

=0+MID(A1,14,10)

otherwise this should work...

=0+MID(A1,LEN(A1)-14,10)