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

Revisited starter script from January 2021: Split Excel file into separate files Excel is essential, and Python is the future - forcing ourselves to practice the latter by automating some of the commo

Message us or

Call us on +44 (0)20 3287 8283

Mon to Fri: 8am-8pm

Weekends: 10am-6pm