title: How to Get Specific number from Narration?
body: <p>I would like to get Number(3035222061) from the below to seperate row. Can u guide me how to get that using Macro or Excel formula?. ( I want to do that becoz daily i need to copy and paste the same thing for 200 line items.)</p>
  
  <pre><code>X-BORDER WIRE FT||CHARGE||USD 593.79||53.8425000||Fvg:GILMAN||PERG8047356553||S0902 TWRDS||CONSIDERATION FOR PATEN||3035222061||TRN REF NO:B01APAF131224JUB
  </code></pre>