Microsoft Office Forums

Go Back   Microsoft Office Forums > Microsoft Excel > Excel Programming

Reply
 
LinkBack Thread Tools Display Modes
  #1  
Old 03-23-2019, 08:59 AM
Baldeagle Baldeagle is offline Windows 10 Office 2013
Advanced Beginner
 
Join Date: Apr 2012
Posts: 61
Baldeagle is on a distinguished road
Default Convert Imported picture to text

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
File Type: xlsx Sample.xlsx (332.7 KB, 2 views)
Reply With Quote
  #2  
Old 03-23-2019, 01:30 PM
macropod's Avatar
macropod macropod is offline Windows 7 64bit Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 19,390
macropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to behold
Default

I suggest you have someone download the list as text rather than as images. If that can't be done online, a branch should be able to arrange for such a list to provided electronically.
__________________
Cheers,
Paul Edstein
[MS MVP - Word]
Reply With Quote
  #3  
Old 03-23-2019, 01:51 PM
Baldeagle Baldeagle is offline Windows 10 Office 2013
Advanced Beginner
 
Join Date: Apr 2012
Posts: 61
Baldeagle is on a distinguished road
Default

I had expressed some surprise at the difficulty they had in getting data downloaded from the Bank website. I'll press them to explore this further either online or direct with the Bank. I myself don't have direct access to the online account.

Thanks for your prompt.
Reply With Quote
Reply

Tags
convert, picture

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Rename a VBA imported picture nsv Word VBA 5 12-14-2017 07:28 AM
Convert an imported chart (picture) to an editable drawing object fishguy Drawing and Graphics 1 05-23-2016 02:23 AM
How to merge text boxes in a large imported document boatfly Word 3 04-20-2016 06:15 AM
I need to convert shaded text into highlighted text on about 80 different long documents. VBA macro? AustinBrister Word VBA 8 05-28-2015 02:42 PM
My plain text post got converted to rich text in a reply, how to convert it back? david.karr Outlook 0 01-05-2012 09:46 AM


All times are GMT -7. The time now is 10:48 AM.


Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.
MSOfficeForums.com is not affiliated with Microsoft