New Text Functions in Excel: REGEXTEST, REGEXEXTRACT, and REGEXREPLACE

New Text Functions in Excel: REGEXTEST, REGEXEXTRACT, and REGEXREPLACE

Explore the new text functions in Excel—REGEXTEST, REGEXEXTRACT, and REGEXREPLACE—that are revolutionizing text analysis and manipulation. Learn how these functions can enhance your productivity and streamline your data processing tasks.

By Rodger Mansfield, Technology Editor 

February 24, 2025

In the realm of data analysis, Excel has long been a trusted ally for professionals across various industries. 

Here's a Cool Tip:  Try the new Regex text functions in Excel.

With the introduction of new text functions—REGEXTEST, REGEXEXTRACT, and REGEXREPLACE—Excel is poised to elevate its capabilities even further. 

These functions leverage the power of regular expressions (regex) to simplify complex text operations, making data manipulation more efficient and precise.

What are These New Text Functions?

Regular expressions, or regex, are sequences of characters that define search patterns, commonly used for string searching and text parsing. 

Unlock Deeper Insights with Google NotebookLM Plus

Unlock Deeper Insights with Google NotebookLM Plus

Google expands NotebookLM, bringing advanced AI-powered document analysis and summarization to a wider audience, while introducing NotebookLM Plus for paying subscribers, offering enhanced capabilities and exclusive features.

By Rodger Mansfield, Technology Editor

February 23, 2024

Have you ever stared at a mountain of documents, research papers, or lengthy reports and wished for a magic wand to extract the essential insights? 

Do you struggle with synthesizing information from multiple sources into a coherent whole? 

Here's a Cool Tip:  Try the new Google NotebookLM Plus.

The NotebookLM tool is evolving, and it's set to change how we process and understand information. 

But now, they have added a paid tier, NotebookLM Plus.

NotebookLM is an AI-powered tool that transforms how users interact with documents. 

Forget the Buttons! Power Off Your iPhone from Control Center

Forget the Buttons! Power Off Your iPhone from Control Center

Tired of fumbling with buttons to power off your iPhone? With iOS 18, you can now turn off your iPhone from the Control Center, making the process faster and easier. 

By Rodger Mansfield, Technology Editor

February 22, 2025

Ever found yourself fumbling with button combinations just to turn off your iPhone?

Turning off your iPhone has traditionally required a series of button presses—a process that, while effective, can be cumbersome. 

Here's a Cool Tip:  Try the new Power Off button in the Control Center.

With the advent of iOS 18, Apple has introduced a simple and elegant solution.

The Control Center serves as a centralized hub for accessing essential features and settings on your iPhone. 

In iOS 18, Apple added a "Power Off" button.

MapQuest's Creative Response to the 'Gulf of America' Renaming

MapQuest's Creative Response to the 'Gulf of America' Renaming

MapQuest has introduced the Gulf Map Generator, a unique tool that allows users to rename the Gulf of Mexico to anything they choose. This interactive feature offers a fun and creative way to engage with maps while sidestepping political controversy. Learn how to use this tool, its benefits, potential drawbacks, and why it’s sparking conversations online.

By Rodger Mansfield, Technology Editor

February 21, 2025

What's in a name?

In the case of the Gulf of America, a lot.

In a bold move that has sparked widespread debate, President Donald Trump signed Executive Order 14172 on January 20, 2025, mandating the renaming of the Gulf of Mexico to the "Gulf of America." 

 This directive has led to varied responses from mapping services and the public alike.

While major mapping platforms like Google Maps and Apple Maps have complied with the executive order by updating their U.S. maps to reflect the new designation, MapQuest has taken a different path. 

This month, MapQuest unveiled the "Gulf Map Generator," a tool that allows users to personalize the name of the Gulf. 

Accessible through a dedicated website, this feature enables individuals to input any name they choose, generating a customized map with their selected label prominently displayed over the Gulf's expanse.

Google Tasks Gets a Powerful Web Makeover

Google Tasks Gets a Powerful Web Makeover

Google Tasks has long been a handy tool, but its new full website version brings a significant upgrade, offering enhanced organization, collaboration, and productivity features. This Cool Tip explores the new interface, its benefits, and how you can leverage it to streamline your workflow.

By Rodger Mansfield, Technology Editor

February 20, 2025

Are you tired of juggling multiple to-do lists scattered across different apps and devices?  

Do you dream of a centralized hub for all your tasks, accessible from anywhere?  

Here's a Cool Tip:  Try the new Google Tasks Website.

Google Tasks has heard your cries for help, and it’s answering with a robust, web experience that promises to revolutionize how you manage your to-dos.  

Google Tasks has been a useful tool for basic task management, but its web interface lagged behind its mobile counterpart.  

The revamped Google Tasks website offers a clean, intuitive interface that makes it easy to create, organize, and manage your tasks.  

Notepad Rewrite: Revolutionizing Text Editing with AI

Notepad Rewrite: Revolutionizing Text Editing with AI

Microsoft's latest Notepad update introduces Rewrite, a feature that leverages AI to enhance and refine text, but it comes with a catch: a paid subscription is required to access it.

By Rodger Mansfield, Technology Editor 

February 18, 2025

Have you ever wished for a personal editor to refine your writing with just a click? 

Here's a Cool Tip:  Use Rewrite in Windows Notepad.

Rewrite in Notepad is a new AI-powered feature introduced in the latest update of Notepad for Windows 11. 

This feature leverages a powerful AI model to help refine and enhance your text. 

Mr. Whiskers is Pretty Good!

Be sure to invite Mr. Whiskers to you next LAN party!  lol.

 READ MORE

• Can You Keep It Down?
• Windows Yoga
• Was It You?
• More One Cool Tip Comics

Please LIKE and SHARE OneCoolTip.com!

Never miss a Cool Tip: OneCoolTip Newsletter.

Visit the OneCoolTip YouTube Channel: https://www.youtube.com/@onecooltip

X: https://twitter.com/OneCoolTip    Threads:   https://www.threads.net/@onecooltip

Do you have a Cool Tip or question? Email us at onecooltip.com@gmail.com

Rodger Mansfield, a seasoned tech expert, is the mastermind behind OneCoolTip, where he serves as both writer and editor. With a keen eye for simplifying complex tech, Rodger delivers practical advice that empowers readers to navigate the digital world with confidence. Dive into OneCoolTip for a treasure trove of savvy tips and tricks that keep you one step ahead in tech.

One Cool Tip

http://www.onecooltip.com

Cool Tech Tips for a Cooler Life!

#cat #videogame #TechTips #OneCoolTip #CoolTipComics @OneCoolTip

Copyright © 2008 - 2025 | www.OneCoolTip.com | All Rights Reserved

Google Gemini's Memory Upgrade: A Game-Changer for AI Interaction?

Google Gemini's Memory Upgrade: A Game-Changer for AI Interaction?

Gemini's new upgraded memory feature allows for more personalized and context-aware conversations, mimicking human-like interaction and significantly enhancing user experience.

By Rodger Mansfield, Technology Editor

February 18, 2025

Have you ever wished your AI assistant could remember details from your previous conversations?  

Imagine an AI that truly understands your preferences and can seamlessly weave them into ongoing discussions.  

Here's a Cool Tip:  Use Google Gemini with Upgraded Memory.

This isn't science fiction anymore. 

Google's Gemini has just received a significant memory upgrade, bringing it closer to that ideal of a truly personalized AI companion. 

This feature, already a popular aspect of ChatGPT, is now poised to revolutionize how we interact with Gemini.  

Microsoft's New Sign-In Changes: What You Need to Know

Microsoft's New Sign-In Changes: What You Need to Know

Starting February 2025, Microsoft will automatically keep users signed in to their accounts unless they explicitly sign out or use private browsing. This change aims to enhance user convenience but raises security considerations for those accessing accounts on shared or public devices.

By Rodger Mansfield, Technology Editor

February 16, 2025

Imagine accessing your Microsoft account without the repetitive hassle of signing in each time. 

While this seamless experience enhances convenience, it also introduces potential security concerns, especially on shared or public devices. 

Here's a Cool Tip:  Be Sure To Log Out of Microsoft Accounts on Public or Shared Computers.

As of February 2025, Microsoft has implemented a significant change to its sign-in process that every user should understand.

In an effort to streamline user experience, Microsoft has updated its authentication process. 

Previously, upon signing in, users were prompted with an option to stay signed in. 

Maximize Your Browser Performance: How to Use Microsoft Edge Sleeping Tabs

Maximize Your Browser Performance: How to Use Microsoft Edge Sleeping Tabs

Discover how Microsoft Edge Sleeping Tabs can improve your browsing experience by reducing resource usage and extending battery life. Learn how to enable and configure this powerful feature with step-by-step instructions.

By Rodger Mansfield, Technology Editor 

February 16, 2025

In today's digital age, maintaining optimal browser performance is essential for both work and leisure. 

Have you ever noticed your computer slowing down with too many tabs open? 

Here's a Cool Tip: Use Sleeping Tabs in Microsoft Edge.

Microsoft Edge has introduced a feature called Sleeping Tabs to address this issue.

Sleeping Tabs is a feature designed to save system resources by putting inactive tabs to "sleep." 

This reduces memory and CPU usage, ultimately enhancing the overall performance of your device.