CONCATENATEX Function

How to Abbreviate Days of the Week in Excel (5 Suitable Ways)

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 Summarize Text Data in Excel (with Easy Steps)

While working in Microsoft Excel we need to make a final report. To make the final report often we make a summarized report for final submission. But ...

How to Summarize Data in Excel Using Pivot Table (2 Examples)

This article illustrates how to summarize data in excel Pivot Table. PivotTable is a great tool in excel to quickly summarize huge datasets even if ...

[Solved]: Leading Zero Not Showing in Excel (9 Possible Solutions)

Sometimes, we need to input a number with the leading zeroes for our dataset. But if the proper settings are not used, we can face difficulties to ...

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 Change Case for Entire Column in Excel (7 Amazing Ways)

To err is human. Sometimes we forget to use the correct pattern while writing. We might lose a lot of valuable time making corrections for those ...

How to Change Case in Excel Sheet (8 Quick Methods)

While working in Microsoft Excel we might find different cases like lowercase, and uppercase in different cells. Sometimes you will find upper and ...

How to Add New Line with CONCATENATE Formula in Excel (5 Ways)

If you are looking for ways to add a new line in Excel using CONCATENATE formula, then you will find this article useful. So, let’s get started with ...

How to Display Day of Week from Date in Excel (8 Ways)

When you are working with to-do lists or daily reports, it is inevitable to display the day of the week from the date in Excel. For any day-specific ...

How to Change Lowercase to Uppercase in Excel (6 Methods)

In this article, we’re going to show you 6 methods of how to change lowercase to uppercase in Excel. For this, we have a dataset containing 2 ...

How to Convert Date to Day of Week in Excel (8 Methods)

02/04/2022 represents a date, it does not provide any information of weekdays. But it is equally necessary to know the day of the week. In this ...

How to Convert Date to Day in Excel (7 Quick Ways)

In our day to day life, it is a must that we have to know the day of a certain date. We can easily convert date to day in Excel. For more ...

How to Keep Leading Zeros in Excel (10 Suitable Methods)

In Microsoft Excel, it’s not possible to keep leading zeros by simply typing a number with 0’s at first as Excel, by default, will remove those zeros ...

Advanced Excel Exercises with Solutions PDF