REPLACE Function

### How to Truncate Numbers in Excel (8 Suitable Methods)

Truncating a number means decreasing the number of digits from the decimal section or from the right side of that number in mathematics. In Excel, ...

### Convert Scientific Notation to x10 to the Power of 3 in Excel

In this article, we will learn how to convert scientific notation to x10 to power of 3 in Excel. We often need the exponential format for writing ...

### How to Truncate Text from Right in Excel (5 Easy Methods)

Fortunately, many of us use Excel in our business organizations. In any business organization, we use Excel to organize data as per need and make ...

### How to Remove Prefix 91 in ExcelÂ (4 Easy Ways)

There are instances when we need to remove the country code while working with a collection of phone numbers in Excel. We may exclude those country ...

### How to Convert Hex to Decimal in Excel (2 Practical Examples)

When working with numbering systems, Hexadecimal and Decimal both systems are significant from their own perspectives. So, it is a frequent need for ...

### How to Remove Inverted Comma in Excel (7 Easy Methods)

When we import data in Excel, we may often encounter some Inverted Comma in data that creates problems while calculating data because it may change ...

### How to Find and Replace Multiple Words from a List in Excel

Looking for ways to find and replace multiple words in a word from an Excel list? Then, this is the right place for you. Here, you will find 8 ...

### How to Add Comma Before Text in Excel (6 Suitable Ways)

Whenever working with Excel you may face a situation where you will need to add comma before text. The main objective of this article is to explain ...

### How to Change Semicolon to Comma in Excel (6 Effective Ways)

Preparing Excel worksheet and have given semicolon mistakenly instead of a comma in your texts? Want to change semicolon to comma but find it ...

### How to Use CHAR(32) Formula in Excel (5 Practical Examples)

The article will show you an application of using the CHAR function in Excel. Suppose you have a range of IDs in the dataset and you want a space in ...

### How to Reduce Excel File Size Without Deleting Data (9 Tricks)

While working with Excel, we often encounter slow and sluggish Excel experiences. In most cases, the main culprit behind this issue is the large ...

### How to Use Comma in Excel Formula (2 Suitable Ways)

If you're looking for quick and easy ways to use comma in Excel formula, this article will be helpful. While working with Excel, we often need to add ...

### How to Create Table of Contents Without VBA in Excel

While working with Microsoft Excel, you may have dealt with several sheets in your workbook. However, if you need to create a table of contents with ...

### 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 ...

### Apply Formula to Identify Special Characters in Excel (4 Methods)

Many times the database contains some special characters which we do not need in the database and we want to identify them. We can easily perform ...

Advanced Excel Exercises with Solutions PDF