TRIM Function

How to Remove Spaces in a Cell in Excel (5 Methods)

Having spaces in texts is quite a common thing. But having unnecessary spaces is a real issue that needs to be resolved. In this article, you will ...

How to Remove Spaces in Excel: With Formula, VBA & Power Query

In Microsoft Excel, there are several effective methods available to remove all sorts of unwanted spaces. You’ll get to know all possible and ...

How to Add Space Between Text in Excel Cell (4 Easy Ways)

It is a common phenomenon in Excel that we import data from external sources. By doing so, we encounter entries void of spaces. In this article, we ...

How to Remove Blank Characters in Excel (5 Methods)

Excel is one of the most widely used applications in our professional life. We organize, calculate, manipulate our data using this Excel. In this ...

How to Remove White Space in Excel (6 Easy Ways)

While working in Excel, the extra space problem is a pretty common issue. In this article, you’ll learn how to remove white space in excel with some ...

How to Remove Leading Spaces in Excel (4 Methods)

While creating a large worksheet it is very much possible to have some extra spaces in the contents. To make an excellent worksheet it is needed to ...

How to Remove 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 remove them. We can easily perform this ...

How to Remove Characters in Excel (6 Methods)

While working with a large dataset, it is not a wise way to remove characters manually when needed. In this article, we will show you how to remove ...

How to Remove the Trailing Spaces in Excel (2 Easy Ways)

We can easily remove unwanted characters or symbols from Excel if they are visible to us. But detecting and then deleting spaces is quite hard as ...

How to Remove Space in Excel before Numbers (3 Ways)

Space between numbers is a common situation while working on Excel. Sometimes, they are intentional. Sometimes, it is a mistake. We give input ...

Subtraction Formula in Excel (7 ways)

We all know basic subtraction. It is mainly finding differences between two or more values. This article will show you subtraction formula in Excel ...

Opposite of Concatenate in Excel (4 Options)

In Microsoft Excel, there is no exact function that works as the opposite of concatenate function. But still, we have a number of suitable procedures ...

10 Best Practices with VLOOKUP in Excel

In Microsoft Excel, the VLOOKUP function is generally used to extract data based on a lookup value in a column or a range of cells. In this article, ...

How to Perform Custom Sort in Excel (with Easy Steps)

Today I will be showing how to perform custom sort in Excel. To perform a custom sort, you can use the default custom list, or you can create a ...

How to Use VBA Trim Function in Excel (5 Practical Examples)

Data cleaning is an important part of data analysis. In Excel, Trim is another most usable function in VBA code which removes extra spaces from the ...

ExcelDemy
Logo