Extracting Numeric data from alphanumeric

Dear Sir,

Kindly look below table,from below I want to extract only the number in Column B & Data from beginning till the number in Column C.

Column>> A
Row
1 Credit Note 03:Ram Hari Yadav

2 Debit Note 4: Srikant Dubey

3 Credit Not 07: Ram Pandit Singh

I will be very much thankful in solving my queries.

Best Rgds,
Suresh

Dear Sir,

Pls find enclosed in attachment.

With Best Rgds,
Suresh

Originally Posted by Rambo4711

See my suggested solution in attached file:

Sorry for the data I put in cell B5:B8 (should not be there)

Dear Sir,

Thanks a lot for it.

With Best Rgds,

Suresh