Help with Images/Alternative Text/VBA

[djm51]

Hello,

I have a excel spreadsheet which has many images (500+) in one column, each row. Each image represents a status (there are approx 5 different images). As I would like to be able to sort the spreadsheet, I was wondering if there was any way to convert the image to text. I did some research and the only way I could see is maybe using the alternative text (each png file has different alternative txt depending on the image). I cant find any way just to display the alternative text instead of the image in each cell, so I guess a macro is the best way

When I select on image it says the pictures name is "Picture 1", therefore I would like a macro what selects Picture 1, gets the alternative text, and pasts it in column I, then moves on to "Picture 2" and so on, till they are all done. Not every row has an image (eg. it could be rows 10-30, 50-75...)

Any ideas?

 

[psriv76]

this is the second image code which needs to be decoded. data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAAHgAAAAVCAYAAACNDipWAAAAAXNSR0IArs4c6QAAAARnQU1BAACxjwv8YQUAAAAJcEhZcwAADsMAAA7DAcdvqGQAAAImSURBVGhD7dfRbVRBDIXhLSAN0AAN0AAVUAEd0EFaoIXUQBN0QTNhviRHsqy7c4EXbiT/kpWdsY8z9ng2cBuGYRiG4RI8LPu+7Meyn8u+LAv2ng/s2zLstBAXza9ln5dVPi6rvyN8Wva0LPtyi63c0yJ71eRE1zm/OkLVxKIVl3Opp9d7SVyCIqEAh+/NDPGn4J1W8XWdy04zPyyzPmrS1zcTyzRVQ8NOC76csSNPziyP9ePL6pWd1mA4C1KfHJfG69DMoIi80I5G8Ied1k/+0AdAk2tjd2Q4wpl2d0l89ZtEnlwazrTVp757vboM/dB1Sit5NTV2p83rsBajkXk5iE8OxpfXXZFHI+trPdNmn9HWb6QMi8G0L1f177T2er3v8oJZRxP7xZ9po9EosfXlWKc5GYbeLLnE+dkbfaaFS3cG8SGXmn25jwbrSBsddr/3Uijg3isMmiJOUZWdVuHWweXW+K7tX/8VPvHhb7TiEu/Sqtaa7k+0yHDYo3kXF+x1nf0NtpfJrey0Pmt8RWPi15z6tSu2D1ZIo8O/aA1nPtcX6zw1d6Vqj+Cr3yyXRIG5vEx4PfSuyJ02jaNH/1cnvwGhs8eXS5Mzn/mtxYad1sDx8zEXb9hgLVa++OVJDTtthY/myHc56mEVW18Gjl5iONPSaSjj7/8Prn6NDfKIj0+j+4Dd0xqornXOYACrP5eNM22GveuGYRiGYRiGYRiGYfgv3G6/ASR477W67LBzAAAAAElFTkSuQmCC

<colgroup><col width="64"></colgroup><tbody>
</tbody>