How to use the CLEAN Function
The CLEAN function removes all non-printable characters from a text string. Characters like line breaks, tabs, and other characters that...
top of page
Recent Posts
Understanding Dynamic Arrays - VBA Tutorial
A dynamic array is an array that can change size on the fly, unlike a static array that has a fixed number of elements. Contents: 1. What...
The Basics to Creating and Using Formulas in Excel
Formulas are an integral part of Excel, and are the defining feature that elevates a workbook far above a simple calculator. Contents: 1....
How to Take the Average of Non-Zero Cells in Excel
Using the standard AVERAGE function with data that contains zeros can give you an incorrect average. Instead, we can use the AVERAGEIF...
How to Abbreviate a Middle Name in a Full Name in Excel
Formatting names can be a manual and slow process. Here is a quick method to turn a middle name into a middle initial when given a full...
How to Separate a Full Name Into First and Last Names in Excel
Often, you'll receive a list of first and last names combined into a full name and need to separate them. Here's a quick method to easily...
How to Combine First & Last Names Into a Full Name in Excel
Often, you'll receive a list of names broken up into two separate columns, first and last, and need to combine them into a full name....
How to Extract Everything to The Left of a Specific Character in Excel
A lot of time spent in Excel is used to clean up data that may not be immediately useful into something valuable. Being able to pull out...
How to use the AND Function in Excel - 3 Examples
The AND function checks if all provided conditions in the function are true, and returns a TRUE. If any of the conditions are false, a...
What are Macros? Are They Hard to Learn? Should You? - VBA Tutorial
Macros are used inside an Excel workbook that automate repetitive and complex tasks, allowing you to streamline your workflow and save...
How to Create a Macro in Excel - VBA Tutorial
Knowing how to create macros will let you automate repetitive tasks and create your own customized features and functions in Excel. There...
How to Extract Everything to The Right of a Specific Character in Excel
A lot of time spent in Excel is used to clean up data that may not be immediately useful into something valuable. Being able to break up...
What are Arrays and How to Use Them - VBA Tutorial
An array is a set of values that are stored in a structured, linear way, allowing you to store and manipulate a large number of values in...
What are With Statements and How to Use Them - VBA Tutorial
In VBA, a with statement is used to reference an object multiple times within a specific block of code. Reducing typing and creating more...
Multi-Sheet References & Formulas - 3-D References in Excel
A 3-D reference is a reference to a range of cells across multiple worksheets in a workbook. For example, if you have a workbook with...
bottom of page