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