How to split text in Excel in 5 ways

How to split text in Excel in 5 ways

In this guide, we’re going to show you how to split text in Excel by a delimiter. Download Workbook We have a sample data which contains concatenated values separated by “|” characters. It is important that the data includes a specific delimiter character...
How to shorten VBA code in Excel

How to shorten VBA code in Excel

How to shorten VBA code in Excel Shortening VBA code can make it much easier to read and maintain. Here, we mean shortening in the sense that some code blocks can be stacked or alternative statements can be introduced to make it more efficient. In this guide,...
How to find formulas in Excel

How to find formulas in Excel

Finding formulas or displaying them can help troubleshoot or improve upon a spreadsheet. In this guide, we’re going to show you how to find formulas in Excel. Download Workbook Go To Special Go To Special is tool for finding not just formulas, but also other...
5 tips for VBA beginners in Excel

5 tips for VBA beginners in Excel

In this guide, we’re going to show you 5 tips for VBA beginners in Excel and get you up to speed in no time! Saving macros – tips for VBA beginners Since the 2007 version, Excel has been differentiating between files containing macros based indicated by...
How to generate Diceware passwords in Excel

How to generate Diceware passwords in Excel

The Diceware method is a password (or passphrase) generation method which you can create strong and easy-to-remember passwords. In this guide, we’re going to show you how to generate Diceware passwords in Excel. Download Workbook Warning Note that it is...