So I'm trying to extract data from images within the sheet but somehow can't. I tried using the Get Data from Picture function but still no result.
Can someone please help?
Thanks
Untitled.png
So I'm trying to extract data from images within the sheet but somehow can't. I tried using the Get Data from Picture function but still no result.
Can someone please help?
Thanks
Untitled.png
Like there's a lot that I don't get here, like how do I know these "Part Numbers" and how do I get their corresponding Size & Frame options? Isn't that in the properties? If so how do I copy data from the properties and how do I know which images does the Part Number correspond to?
A non-editable PICTURE is quite useless. Please upload an Excel file, showing us what you have and what you want.
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.
Temporary addition of accented to illustrate ongoing problem to the TT: Lá fhéile Pádraig sona dhaoibh
Hi,
I guess this is a homework. You don't need the images at all.
Just the Part Number in column A.
For size, you need a function to extract the text between delimiters and for frame, a function that extract the text after the second delimiter if it exist.
Use TEXTBEFORE, TEXTAFTER and IFERROR functions
Diana Tanase
If the solutions offered helped you to solve your problem, then mark the thread as SOLVED (thread tools in the top menu) and you can click on * to add reputation to those who helped you, as a way to say thank you !
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks