Excel Tips and Tricks

How to slugify a string with Excel

How to slugify a string with Excel

“Slugify” is a term for converting strings into URL slug format. A URL slug, or just slug in this article’s context, is the part of the URL that comes after the domain extension. In this guide, we're going to show you how to slugify a string with Excel. [button...

How to split text with Power Query in Excel

How to split text with Power Query in Excel

Power Query is a data management tool in Excel. In this guide, we're going to show you how to split text with Power Query in Excel. [button link="https://www.spreadsheetweb.com/wp-content/uploads/2021/03/How-to-split-text-with-Power-Query-in-Excel.xlsx" type="big"...

How to disable protected view mode in Excel

How to disable protected view mode in Excel

Excel opens most files from other sources in Protected View mode by default. In this guide, we're going to show you how to disable protected view mode in Excel. Excel, like most other Office applications such as Word and PowerPoint, shows this message to ensure that...