| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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.. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| second word in a string | Excel Discussion (Misc queries) | |||
| Matching CELL text (full word) to full word in string in another | Excel Programming | |||
| How do I extract a word from a string? | Excel Programming | |||
| WORD-DELIMITED string vba macro for excel/word | Excel Programming | |||
| identify a word in a string then change the format of that word | Excel Programming | |||
![Curious[_6_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
