IT General

Most Excel users know Ctrl+F as a quick way to find specific text or values in a spreadsheet. You might also know Ctrl+H, but probably think of it as little more than a way to replace one value with another. For years, I overlooked how much more it could do. From cleaning up messy imports to fixing formatting issues, Find and Replace is one of Excel's most underrated cleanup tools.

Now and then, I come across a movie that makes me wonder how I hadn't heard of it sooner. This is especially true with Netflix titles, because there's so much to choose from, what with its original library and new, licensed titles arriving every month in the U.S.

If you thought K-pop comeback promotions had reached their limit, Hearts2Hearts would like a word.

Ahead of the release of its second mini album, Lemon Tang, the rookie SM Entertainment girl group introduced fans to Tangy, an adorable lemon mascot who quickly became the unlikely face of the comeback. What started as a series of mysterious social media posts asking fans to keep an eye out for the citrus character soon evolved into one of the strangest album promotions in recent memory: Tangy was launched more than 30 kilometers above Earth aboard a custom-built high-altitude balloon.

Yes, really.

Tangy in near space. Credit: Courtesy of Sent Into Space

The launch served as the grand finale of Hearts2Hearts' "Missing Tangy" campaign, a weeks-long social media mystery that treated the smiling citrus like a missing celebrity. Fans were encouraged to report sightings, piece together clues, and speculate about Tangy's whereabouts before the group finally revealed the mascot's improbable destination.

According to aerospace marketing company Sent Into Space, which partnered on the campaign, the mission required considerably more planning than simply tying a lemon to a weather balloon.

The engineering team designed a custom-molded flight seat built specifically for Tangy's "lemon-shaped posterior," complete with a concealed safety harness to keep the mascot secure during the journey. They also 3D-printed a miniature pair of heart-shaped sunglasses so Tangy could travel in style.

Tangy traveling in style. Credit: Courtesy of Sent Into Space

On launch day, the hydrogen-filled balloon carried Tangy into what Sent Into Space describes as near space, ascending for roughly 90 minutes to an altitude of more than 33 kilometers — above 99.5 percent of Earth's atmosphere. At that height, the curvature of the Earth becomes visible while the sky fades into the deep black associated with space.

The balloon itself expanded to nearly 30 meters in diameter — roughly the height of the White House — before bursting as planned. Tangy's spacecraft then descended beneath a parachute, completing a flight that lasted about three hours from launch to landing.

"Collaborating with Hearts2Hearts to celebrate their latest album release was an absolute pleasure, and the entire Sent Into Space team had a fantastic time launching everyone's favourite lemon to over 30km above the Earth," Dr. Chris Rose, head of project at Sent Into Space, said in a statement shared with Mashable. "Tangy did prove to be a bit of a slippery customer, though, managing to escape before we could bring him in for a post-flight debrief…"

View this post on Instagram

A post shared by Hearts2Hearts H2H (@hearts2hearts)

The joke fit neatly into the campaign itself. Rather than ending with the launch, the story continued with Tangy's playful "escape," extending the mascot's narrative beyond the mission and giving fans one last chapter in the adventure.

The entire journey was documented on video, including exclusive behind-the-scenes footage shared with Mashable that shows engineers preparing Tangy's tiny spacecraft, fitting the mascot with its custom sunglasses, and completing final checks before liftoff.

It's the kind of rollout that's becoming increasingly common in K-pop, where comeback promotions have evolved into multimedia experiences designed to fuel fan conversation long before an album arrives. Whether it's alternate reality games, fictional universes, interactive websites, or elaborate real-world stunts, agencies are increasingly treating album campaigns as immersive stories rather than traditional marketing.

Sending a lemon 33 kilometers above Earth may be one of the more delightfully absurd examples.

But that's precisely why it worked. Fans weren't just anticipating "Lemon Tang" — they were following a little lemon's journey from internet mystery to near-space traveler.

Google Pixel phones have plenty of cool features, but when it comes to automations, they’re a bit lacking. Still, even with the limited options, I’m able to make my Pixel automatically change certain settings based on my location.

Badge prestige still carries a lot of weight in the sports sedan world, which is why many buyers automatically gravitate toward the usual German luxury brands. That can be an expensive habit, especially when there are overlooked alternatives offering comparable performance, premium interiors, and engaging driving dynamics for thousands less.

Got an old Chromecast sitting in a drawer unused? It doesn't matter if you no longer need it for streaming, there are plenty of other ways to make use of it. So connect it to your TV, update the software, and try one of these ideas to repurpose your old Chromecast.

Your modem is probably one of the least-checked devices in your home. After all, how often do you really need to look at it? Only if your internet goes down, I'd imagine.

When it comes to summer binges, I prefer a riveting series over anything else. In a world where our minds are constantly focused on multiple things at a time, there's nothing better than tuning all that out with something completely engrossing that keeps me hooked.

Your Google Pixel has many clever features, some tucked away in menus or introduced quietly. If you’ve updated to Android 15 or even if you’re running an older version, there’s a good chance you’re missing out on some of these hidden gems.

For a long time, the Raspberry Pi was the default choice for any project that called for an SBC because it was affordable and well-supported. Unfortunately, things have changed. Memory prices have pushed the top-shelf Pi 5 from its original price of $120 to above $300. The low-memory models are still affordable, but the calculus around which board you should buy is no longer quite so cut and dry.

There's a category of apps that quietly run in the background, doing their jobs and making your life easier. You set them up once, configure them the way you want, and then forget about them as they keep working behind the scenes, quietly paying dividends. Here are three free and open source (FOSS) apps that fit that set-it-and-forget-it philosophy. You can set up all three in a single Saturday afternoon, and they'll continue working in the background for weeks and months to come.

If your T-Mobile service was disrupted on Monday, you may be able to get some compensation for your troubles.

Multiple outlets, including KTLA in Los Angeles, have reported that some T-Mobile customers have been able to get at least $20 off their next bill because of the outage. One Reddit user said they were able to save as much as $80 (spread out over multiple billing cycles) by telling customer service that they missed out on a work opportunity because of the outage.

SEE ALSO: T-Mobile is giving away the Apple iPhone 17 for free — how to qualify

Generally, it seems that these credits are not automatic, and you may have to personally contact T-Mobile customer service to be compensated for your troubles.

After a major Verizon mobile outage in January, Verizon offered all affected customers a $20 credit.

Millions of T-Mobile users found their phones stuck in SOS mode on Monday afternoon, which led to plenty of criticism of the brand on social media. T-Mobile did acknowledge and apologize for the outage, though it has not explained what happened.

This Tweet is currently unavailable. It might be loading or has been removed.

Mashable contacted T-Mobile repeatedly to ask about the outage and its causes, but so far, the company has been silent. The most recent post at the T-Mobile news page is the company's Q2 2026 earnings report, in which the company saw growing revenue and profits, with total revenue for the quarter of $22.7 billion.

If you've ever used a handheld gimbal camera and wished it could just float into the air to grab a wide shot, HOVERAir built something specifically for you. The company just announced the VERSA, a pocket camera designed to work both on the ground and in the air.

SEE ALSO: The best cameras for vlogging

Most of the time, it functions as a standard handheld camera with a 3-axis gimbal to keep your video steady. It uses an AI framing feature to analyze your shot, suggest where to place the camera, and automatically crop the frame. HOVERAir also says it handles low-light and high-contrast scenes without blowing out the highlights or losing shadow detail.

HOVERAir is introducing VERSA, a pocket camera that can fly. Credit: HOVERAir

When you want an overhead perspective, you snap on a set of lightweight propeller wings. You don't need a controller or piloting experience — you launch it right out of your hand and let the AI tracking follow you around. It comes with more than 10 automatic flight modes, including a "3D Worlds" setting that flies a 360-degree circle around you to create a three-dimensional image.

The VERSA is set to launch on Indiegogo in mid-August. The official site is live with these initial details, but HOVERAir hasn't shared pricing or the full spec sheet yet.

Opens in a new window Credit: HOVERAir HOVERAir VERSA   Learn More

SAVE $404: As of July 31, the DJI Mavic 4 Pro Fly More Combo — which includes the drone, DJI RC 2, three batteries, charging hub, shoulder bag, and more — is on sale for $2,495 at Amazon. That's 14% or over $400 in savings.

Opens in a new window Credit: DJI DJI Mavic 4 Pro Fly More Combo $2,495 at Amazon
$2,899 Save $404   Get Deal

If you're looking to elevate your travel content, vlogs, real estate videos, home movies, or commercial projects, DJI drones are the way to go. And if you really want top-tier aerial footage, the Mavic 4 Pro is hard to beat, particularly if you can find it on sale.

The DJI Mavic 4 Pro is a lofty purchase at $2,899, which puts it out of reach for those who just want to dabble in drone content. Instead, it's built for video professionals looking to up their cinematic footage. The Fly More Combo, which includes the DJI Mavic 4 Pro, the DJI RC 2, three batteries, a charging hub, and more, is on sale on Amazon for $2,495. Yes, that's still pricey, but it's over $400 cheaper than usual.

Mashable Deals Be the first to know! Get editor selected deals texted right to your phone! Get editor selected deals texted right to your phone! Loading... Sign Me Up By signing up, you agree to receive recurring automated SMS marketing messages from Mashable Deals at the number provided. Msg and data rates may apply. Up to 2 messages/day. Reply STOP to opt out, HELP for help. Consent is not a condition of purchase. See our Privacy Policy and Terms of Use. Thanks for signing up!

The Mavic 4 includes a 100MP Hasselblad camera paired with a 48MP medium telephoto at 70mm and a 50MP far-reach telephoto at 168mm. It can shoot 6K/60fps HDR video on the main camera and 4K/120fps HDR video across the three cameras combined. Another added bonus is the infinity gimbal, which offers 360 degrees of rotation for magical shots from virtually any angle.

You'll get about 51 minutes of flight time with the Mavic 4 Pro's battery, but you can swap it for one of the extra batteries included for longer sessions. You'll also get a fast-charging hub with the Fly More Combo, helping you get back up in the air faster.

While it's certainly a major investment, our friends at CNET (also owned by Mashable's publisher, Ziff Davis) raved about it. "The Mavic 4 Pro is a superb option for video professionals who want to add some truly cinematic drone footage to their image-making arsenal."

It's worth that $2,495 sale price for the right creators.

SAVE 48%: As of July 31, you can get the Kingston Fury Renegade G5 SSD (2048GB) for $379.99 at Amazon. That's a 48% discount or $353 in savings.

Kingston Fury Renegade G5 SSD (2048GB) $379.99 at Amazon
$732.99 Save $353   Get Deal at Amazon

If you're tired of deleting old games just to make room for a single new update, it might be time to look into upgrading your internal storage.

Right now, you can get the Kingston Fury Renegade G5 SSD (2048GB) for $379.99 at Amazon, down from $732.99. That's a 48% discount or $353 in savings.

SEE ALSO: RAMageddon is making it harder to find the best Windows laptops. These 10 are actually worth it.

It’s still a spendy upgrade, but this is one of the fastest drives on the market. It delivers read speeds up to 14,800 MB/s and write speeds up to 14,000 MB/s, so game load times and large file transfers happen almost instantly. And because Gen 5 drives are known for running hot when pushed, Kingston designed this one with a specialized thermal layout (a 6nm controller and a 12-layer PCB) to help manage heat and prevent the drive from throttling under heavy workloads.

That said, there is one thing you should know before buying: it uses the standard M.2 2280 form factor and works with older Gen 3 and Gen 4 systems, but you need a motherboard that supports PCIe 5.0 to reach the advertised 14,000 MB/s speeds.

SAVE 44%: As of July 31, you can get a 27-inch LG Ultragear OLED gaming monitor (27GS93QE) for $499.99 at Amazon. That's a 44% discount or $400 in savings.

27-inch LG Ultragear OLED Gaming Monitor $499.99 at Amazon
$899.99 Save $400   Get Deal at Amazon Get Deal at Best Buy

If you've been wanting an OLED monitor but refuse to pay OLED prices, today is your day. Amazon just knocked 44% off the 27-inch LG UltraGear OLED gaming monitor, bringing it down to $499.99. That's a record-low price.

SEE ALSO: The best TVs of 2026 so far: RGB TVs were the talk of CES, but they're not the only exciting releases

OLED screens are notorious for being expensive, but they're also genuinely worth it if you care about picture quality. Because this monitor features VESA DisplayHDR True Black 400, the blacks actually look black, not that washed-out dark gray you get on standard screens. It also has a 240Hz refresh rate and a 0.03ms response time, which is just a fancy way of saying your games will run super fast without tearing or lag.

A few other nice-to-have features: the screen is anti-glare, and the stand lets you adjust the height, tilt, and pivot to match your setup. Plus, LG includes a two-year warranty that covers the OLED panel itself.

SAVE $30: As of July 31, get the Apple AirPods 4 for just $99 at Amazon. That saves you $30 off its $129 price tag.

Opens in a new window Credit: Apple Apple AirPods 4 $99 at Amazon
$129 Save $30   Get Deal

If you're an iPhone user, you can't deny the convenience of Apple's AirPods. The earbuds are perfectly pocket-sized and automatically connect to your iPhone, which means no unnecessary fussing with Bluetooth controls. The biggest downside to AirPods is the price.

When you're used to the days of Apple providing a pair of EarPods with every phone, it's a tough pill to swallow when you see AirPods $129 price tag. Luckily, you don't have to spend that much on them.

Mashable Deals Be the first to know! Get editor selected deals texted right to your phone! Get editor selected deals texted right to your phone! Loading... Sign Me Up By signing up, you agree to receive recurring automated SMS marketing messages from Mashable Deals at the number provided. Msg and data rates may apply. Up to 2 messages/day. Reply STOP to opt out, HELP for help. Consent is not a condition of purchase. See our Privacy Policy and Terms of Use. Thanks for signing up!

As of July 31, get the Apple AirPods 4 for just $99. That saves you $30 off the earbuds' list price for 23% savings.

Apple AirPods 4 debuted in 2024. They're outfitted with the H2 chip and spatial audio. This pair doesn't have active noise cancellation, but it is sweat- and water-resistant for your workouts. Plus, with the included charging case enjoy up to 30 hours of battery life.

Shop the Apple AirPods 4 at Amazon for $99 now and save $30.

Mechanical moving parts are among some of the most satisfying objects you can print. Here are six of our favorites, from fidget spinners for idle hands through to toys, decor, and educational projects.

SAVE $162: As of July 31, the Samsung 55-inch M80H Mini LED 4K TV is on sale at Amazon for only $537.99. That's 23% in savings and its lowest price on record.

Opens in a new window Credit: Samsung Samsung 55-inch M80H Mini LED 4K TV $537.99 at Amazon
$699.99 Save $162   Get Deal

Traditionally, it may not be the best time to buy a new TV, but logically, it certainly is. Not only is the 2026 NFL season right around the corner, but plenty of new movies and TV shows will also hit the airwaves in the coming months (Mother Mary, Ted Lasso Season 4, Reacher Season 4, Survivor Season 51, more than likely Disclosure Day, etc.). Plus, this Samsung Mini LED model is down to its best price ever.

As of July 31, the Samsung 55-inch M80H Mini LED 4K TV is just $537.99, down from $699.99. That's a saving of over $160, marking its lowest price on record according to our favorite price-tracking tool.

Mashable Deals Be the first to know! Get editor selected deals texted right to your phone! Get editor selected deals texted right to your phone! Loading... Sign Me Up By signing up, you agree to receive recurring automated SMS marketing messages from Mashable Deals at the number provided. Msg and data rates may apply. Up to 2 messages/day. Reply STOP to opt out, HELP for help. Consent is not a condition of purchase. See our Privacy Policy and Terms of Use. Thanks for signing up!

The M80H is a step up from your basic LED TV, featuring a Mini LED display that uses loads of tiny LEDs for brighter, more accurate colors and more cinematic contrast. It's not as impressive as an OLED TV, but it's definitely more preferable if you're on a budget. It also includes an NQ4 AI Gen2 Processor, which has companion features like Samsung Vision AI and the AI Sound Controller. These added perks let you elevate specific parts of the sound or add more depth to certain scenes.

For gamers, the M80H is a solid pick, as it features the Motion Xcelerator 144Hz for supporting PC gaming, DLG 240Hz for smoother motion and response times, AMD FreeSync Premium, and an in-game menu that lets you control FPS, input lag, and more.

If your old TV has seen its final days, there's never been a better time to grab Samsung's 55-inch M80H Mini LED TV.

It's only been a few months since Logan Paul's $16 million Pikachu Illustrator Pokémon card sale set a record, but he's already on the hunt for something more valuable.

The controversial YouTuber-turned-WWE star released a one-hour mini-documentary on YouTube on Friday, chronicling his quest to acquire a card that doesn't exist yet.

So what exactly is he trying to do, and why is the Pokémon card he's trying to acquire potentially so valuable? Let's break it down.

SEE ALSO: I tried to buy my son some Pokémon cards at retail price. It was almost impossible. Which Pokémon card is Logan Paul trying to acquire?

In a nutshell, the origin of Pokémon cards can be dated back to 1996. Rather than being sold in packs, the first trading cards were available to peel from sheets found in a Japanese comic called CoroCoro. Pairs of cards were released over a number of issues, with the first – issue 223 – containing Pikachu and Jigglypuff cards.

The catch? Although there are many of these cards in circulation, there is apparently still no Pikachu that's been graded a perfect 10 by the Professional Sports Authenticator (PSA) body.

The video above chronicles Paul's attempt to secure one, following him as he buys copies of CoroCoro 223 along with pre-production sheets of the cards that came with the issue, hoping to peel a Pikachu card that's high enough quality to make the grade of Gem Mint 10 (categorised on PSA's website as a "virtually perfect card").

This Tweet is currently unavailable. It might be loading or has been removed. When will we know if Logan Paul has acquired the PSA 10 Pikachu?

This is the big question. Normally getting cards graded with PSA takes time (from five to 25 business days), but in the documentary we see Paul getting two cards graded far more quickly after dropping them off at one of the PSA offices himself.

At the end of the video, he announces a live streaming event where he will peel the Pikachu card that he hopes to get graded a 10. What we don't know is what will happen next. Will the event end with Paul showing the card off and getting ready to take it to PSA? Or does he have the kind of relationship with the authenticator where he'll be able to organise for one of its graders to attend the event, and do the grading in person?

We'll have to wait for the stream, which is happening July 30 at 9:30 p.m. EST on Paul's YouTube channel, to find out.

Featured Video For You Boys on the internet are telling me nicotine is a productivity hack

UPDATE: Jul. 31, 2026, 2:45 p.m. Logan Paul completed his livestream on Thursday, peeling the Pikachu on YouTue — but based on the card's centering, he doesn't think it'll achieve the PSA 10 grade needed to complete his mission.