CONCATENATE Function

How to Format Phone Number with Country Code in Excel (5 Methods)

If you are searching for some special tricks to format phone number with country code, you are in the perfect place. In this article, we’ll discuss ...

How to Write 001 in Excel (11 Effective Methods)

Excel automatically removes the leading zeros from a number when you enter it in a  cell. Therefore, you cannot directly write 001 in excel and ...

Concatenate Multiple Cells but Ignore Blanks in Excel (5 Ways)

In Microsoft Excel, you will encounter various situations where you will have to concatenate multiple cells. It is one of the crucial Excel tasks. ...

How to Concatenate Date That Doesn’t Become Number in Excel (5 Ways)

When your dataset has values like dates, numbers, texts etc. and you want to concatenate them, Excel throws some random numbers at you. To ...

How to Convert Multiple Columns into a Single Row in Excel (2 Ways)

In Microsoft Excel, converting multiple columns to a single row is one of the familiar tasks. You will find yourself in a lot of situations where you ...

How to Remove Year from Date in Excel (5 Easy Ways)

There are a couple of ways to remove year from date in Excel. Functions such as TEXT; offer a format to enter, MONTH and DAY; extract month and day ...

How to Merge Cells Using Excel Formula (8 Simple Ways)

Merge is an excellent and powerful tool in Excel that lets you merge or combine multiple across different columns or cells under the same column. The ...

How to Add Blank Space Using Excel Formula (6 Methods)

Sometimes while working with Excel you might need to add blank space before and after the cell values. You might need to add the blank spaces to ...

Combine Texts from Two Columns in Excel (6 Easy Tips)

Sometimes while using Excel we feel the need to combine columns containing text. There are some quick and easy methods to combine texts from two ...

How to Merge Text from Two Cells in Excel (7 Methods)

Sometimes we need to merge multiple cells into one for getting the desired output. Undoubtedly, Excel provides some quickest features to do that. In ...

How to AutoFill from List in Excel (8 Quick Ways)

Often we need to use AutoFill for filling the cell or cell range downwards, upwards, and so on instead of entering the data repeatedly. How would you ...

Add Text and Formula in the Same Cell in Excel (4 Examples)

Excel is a great tool to analyze and organize data. Sometimes we need to use a lot of formulas in Excel. By default Excel only shows the formula ...

Keep 0 Before a Phone Number in Excel (6 Methods)

In some cases, a number starts with zero (0). Such as phone numbers, credit card numbers, product codes, postal codes, personal identification ...

How to Combine Cells Using Excel Formula (6 Methods)

When dealing with Microsoft Excel, we occasionally need to combine cells with their values using Excel formulas. We can easily apply the Excel ...

How to Use Phone Number Format in Excel (8 Examples)

If you are looking for some of the easiest ways for Excel phone number format, then you are in the right place. By following this article, you will ...

ExcelDemy
Logo