A small charity that I assist has recently changed its banking arrangements. When they download a file from the Bank's website containing all the payees that they have entered into the Bank's online system it appears as a list containing 'pictures' of the payees' names and the sort code & account number. This isn't really usable to integrate with the Charity's other files.

Is there a simple way for the data in this downloaded file to be converted so that the data is actually contained in each of the cells?



When I tried to edit a sample to attach to this question (in order to anonymise the details) it wouldn't let me until I agreed to convert it 'to a Microsoft drawing object'. Don't know whether this will have confused your ability to assist but I am attaching a sample file which I have converted and I have also pasted a copy of the message that I got and said 'yes' to.

Any help would be very much appreciated.

Attached Files

Sample.xlsx (332.7 KB, 10 views)