How can I strip out the recipient from the transaction narrative?


Some text manipulation can be used to cut out the sections of the narrative that interest you. This formula looks for 'from' or 'to' and displays the text after these keywords. If neither word exist, the whole narrative is displayed.

=IF(ISNUMBER(SEARCH("from",INDIRECT("RC[-1]",FALSE))), MID(INDIRECT("RC[-1]",FALSE),SEARCH("from",INDIRECT("RC[-1]",FALSE))+LEN("from")+1,LEN(INDIRECT("RC[-1]",FALSE))), IF(ISNUMBER(SEARCH("to",INDIRECT("RC[-1]",FALSE))), MID(INDIRECT("RC[-1]",FALSE),SEARCH("to",INDIRECT("RC[-1]",FALSE))+LEN("to")+1,LEN(INDIRECT("RC[-1]",FALSE))),A1))

#Formula #Excel #All

Recent Posts

See All

Frequently Asked Questions, by phone

I have a warning message When does it happen? Can you send a screenshot to us? Also, if you can, please email the PDF input document to us (or upload it using the 'File' menu within StatementReader) a