Bank reference changed format help

PixelPixie 1 Posts Friday September 15, 2017Registration date September 15, 2017 Last seen - Sep 15, 2017 at 03:14 PM - Latest reply: ac3mark 9361 Posts Monday June 3, 2013Registration dateModeratorStatus May 25, 2018 Last seen
- Sep 15, 2017 at 03:54 PM
Hello,

I am trying to reconcile some standing order income at work, we have changed bank account and the reference has changed format! The process i normally use doesn't work now. We normally use access and create a relationship using the reference to find other info ready to import into our database but its no longer matching as the format has changed- help!

Eg it used to come like this:

JANE DOE FPI
012345



And now it comes like this:
JANE DOE ,012345

FPI has disappeared and a comma has been added.
JANE DOE and 012345 are constant

Is there a way to use excel to find the cell that contains JANE DOE and 012345? Then return different values from the same row?

I hope that makes sense
See more 

Your reply

1 reply

ac3mark 9361 Posts Monday June 3, 2013Registration dateModeratorStatus May 25, 2018 Last seen - Sep 15, 2017 at 03:54 PM
Respond to ac3mark