3 posts shown.
Elizabeth Booth2 said:Hey there!
I'm pretty new to this forum, so bear with me if I mess anything up.
Does anyone here know how to actually insert an image into an Excel sheet? Look, I'm not such a total amateur that I don't know how to hit "insert," but I need the image to land in a specific spot, and—here's the kicker—the image choice needs to change based on whatever value is sitting in a certain cell. Any ideas?
https://www.google.com/search?q=inse...x-a&channel=sb
Thanks Kyle Johnson2, seriously, props to you man, you really went all out on this one. I just slapped those formulas in and they work like a charm!🙏🙂
Hey,
anyone out there actually have a fix for this headache?
Here’s the deal: I’ve got three columns in Excel. The first two are totally fine, but column three is a disaster. I need to swap out "Alpbach" for whatever city is sitting right there in the middle column.
I managed to grind through the first 19 rows manually, but now it’s getting ridiculous. From row 20 to 28, I need "Alpbach" replaced with "Arlberg." Then from 29 to 27—wait, my numbering is all over the place, but you get it—it needs to be "Alpbach Axamer," and so on.
This goes on for over a thousand rows. If there was some way to do a lightning-fast replace, I wouldn't be losing my mind here.
Can we cook up a formula or maybe a macro to handle this?
If it helps, I could just set up a fourth column filled with all these specific cities that are supposed to take over for "Alpbach" in the third column. Then maybe a formula could just point to that fourth column as a fixed reference and swap everything out in column three automatically.😕
Right now, I’m stuck highlighting nine rows at a time and manually replacing "Alpbach" with the city for that specific line. It's soul-crushing.