Excel Formulas

How to Add Text in Excel Spreadsheet (6 Easy Ways)

Users frequently need to add text in Excel spreadsheet. In this way, they are able to communicate text data. They might need to add a prefix or ...

How to Put Comma After 2 Digits in Excel (9 Quick Methods)

When you want to keep data with many digits then you may need to put Comma after 2 digits for easier understandability in Excel. In this article, I ...

How to Add a Word in All Rows in Excel (4 Smart Methods)

Sometimes we need to add a specific word before or after a text in all rows in Excel. If you input manually in every row then it’s not feasible and ...

How to Add Digits to a Number in Excel (8 Easy Methods)

Sometimes you may need to add digits to a number in Excel. In this article, I will explain how to add digits to a number in Excel. How to Add ...

How to Add Leading Zeros to Make 10 Digits in Excel (10 Ways)

If you are working with Microsoft Excel, you might find that leading zeros before numbers are removed automatically. Excel’s default options remove ...

How to Add Text to Beginning of Cell in Excel (7 Quick Tricks)

In this tutorial, I am going to share with you 7 quick tricks to add text to the beginning of a cell in Excel. You may need to append extra text in a ...

How to Use XLOOKUP to Return Blank Instead of 0 -12 Methods

The following dataset contains the names of Sales Reps, Product Names, and Sales.   Method 1 - Utilizing an Optional Argument of ...

How to Find Special Characters in Excel (3 Easy Methods)

This tutorial will demonstrate the steps to how to find special characters in Excel. We use different special characters like comma(,), dot(.), ...

How to Add Text to End of Cell in Excel (6 Easy Methods)

There might come some instances, where you need to add text to the end of a cell or cells in Excel. Microsoft Excel enables you to do such tasks in ...

How to Convert 8 Digit Number to Date in Excel (3 Effective Ways)

Sometimes, you have a column of data that contains dates in the form of numbers, and you need to convert those numbers into dates. If you have a ...

How to Put Comma after 3 Digits in Excel (7 Useful Methods)

The use of commas is an essential part of numbers in excel. It is represented as the accounting position in a set of numbers that isolate thousands, ...

How to Insert Character Between Text in Excel (5 Easy Methods)

The following dataset has the State and Number columns. Using this dataset, we will demonstrate how to insert characters between text in Excel. ...

How to Add Text to Multiple Cells in Excel (10 Easy Methods)

Suppose you have a list of proverbs, which includes ten popular English proverbs. Now, you want to add text to these proverbs. In most cases, you’ll ...

How to Add 1 to Each Cell in a Column in Excel (5 Easy Methods)

This tutorial will demonstrate the steps of how to add 1 to each cell in a column in Excel. When you are making a list of different products or a ...

How to Add Text to Cell Without Deleting in Excel (8 Easy Methods)

When we input a large amount of data into our dataset, we unconsciously miss some text of that data. Moreover, sometimes we need to add a specific ...

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo