Extract Numeric value from a string

[77winston]

Hi,
I hope someone can help me with excel issue i seem to be having.
I have the following data.
Column A is for ID and column B is for Notes.
I need find a formula that will extract the number that is highlighted in red and place it in column C.
would this be possible?
Please help.

ID INTERNAL NOTES 355104 Customers Grandson Shaun called in and had questions about the scheme. Verified personal details which identified him as a family member and explained the process. Also asked if he could aske someone to be in attendence on the day to assist with interpreting. He would try to assist. Entered by: Shalom Kaa Entered Date: 25/07/2013 9:42:34 AM ========================================================= Job confirmed to take place on 6/08 with son Andrew. Entered by: Patricia Mackin Entered Date: 24/07/2013 10:31:32 AM ========================================================= I rang only number listed, it rang out, I tried again and cust answered phone, in broken English she gave me her son Andrew's mobile number. Entered by: Patricia Mackin Entered Date: 24/07/2013 10:24:58 AM ========================================================= Called customer using TIS (job #130824435), customer advised she will get her grandson to call and interpret for her as she didn’t want to make the appointment until she spoke to him. Waiting for him to call back now. Entered by: Shalom Kaa Entered Date: 23/07/2013 2:45:16 PM ========================================================= The cust appeared to answer, I had expalined to the interpreter that the cust is a bit deaf as per our notes but cust hung up. Entered by: Patricia Mackin Entered Date: 19/07/2013 11:51:21 AM ========================================================= TIS job number is 130807425. Entered by: Patricia Mackin Entered Date: 19/07/2013 11:48:17 AM ========================================================= 355489 TIS job number is 130675537. Entered by: Patricia Mackin Entered Date: 19/06/2013 4:33:14 PM ========================================================= <colgroup><col><col></colgroup><tbody> </tbody>

<colgroup><col></colgroup><tbody>
</tbody>

 

[77winston]

Thanks Everyone for your input. Really appreciate the help.

apo, thanks for the test workbook. It's brilliant.

Thanks again.

 

[hiker95]

77winston,

Thanks for the feedback.

You are very welcome. Glad we could help.

Come back anytime, and, have a great Holiday Season.