Matt - Excel Calculations - Page 8 of 78

About Matt

Hi, I’m Matt, an expert of MS Excel and a blogger. I help people learn, improve, and master MS Excel skills with practical and fun tutorials, tips, and tricks. I’ve been using MS Excel for over 10 years, and I’ve learned everything from formulas, functions, charts, pivot tables, macros, and more. I’ve also used MS Excel to solve real-world problems, automate tasks, and create amazing reports and dashboards.

How to Use the PROPER Function in Excel

The PROPER function is a text function that converts the initial character of each word…

How to use the UPPER function in Excel

The UPPER function is a text function that converts any text from lowercase to uppercase.…

How to use the LOWER function in Excel

The LOWER function in Excel is a text function that converts all letters in a…

How to use the FIND function to combine text and date in Excel

In this article, you will learn how to use the FIND function in Excel to…

How to Use the REPLACE Function to Replace and Calculate in Excel Formula

The REPLACE function in Excel is a text function that allows you to replace a…

How to Use the SUBSTITUTE Function in Excel to Combine and Separate Columns

The SUBSTITUTE function in Excel is a text function that can replace text in a…

How to use the SUBSTITUTE function to remove word wrapping in cells in Excel

Sometimes, when you copy and paste text from another source into Excel, you may encounter…

How to Use the SUBSTITUTE Function in Excel to Convert Numbers to Words

Sometimes, you may need to convert numbers to words in Excel, such as writing a…

How to use the SUBSTITUTE function in Excel

The SUBSTITUTE function in Excel is used to replace one or more instances of a…

How to Use the SUBSTITUTE Function in Excel

The SUBSTITUTE function in Excel is used to replace one or more instances of a…

hit counter