View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Curious[_6_] Curious[_6_] is offline
external usenet poster
 
Posts: 22
Default Get word from a string

This is a record from bank statement:

WIRE TYPE:FX OUT DATE:081104 TIME:1701 ET TRN:2008103100323691 FX:GBP
92.83 1.624484 BNF:ZEN INTERNET LTD ID:29366585 BNF BK:NATWEST BANK
ID:SC010744 PMT DET:0000002005115610FROM JUPITERRESEARCH PRO-FORMA
NUMBER 6290280

I want to use Function or Code to get ZEN INTERNET LTD, that is the
words between BNF and ID. Beneficiary's name could be 2, words, 3
words, 4 words, so that there is no pattern.

How could I do this? Please advise. Thanks a lot!

H.Z..