CONCATENATEX Function Archives

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

Feb 12, 2023

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 Abbreviate Days of the Week in Excel (5 Suitable Ways)

How to Summarize Text Data in Excel (with Easy Steps)

Dec 11, 2022

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

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

Feb 9, 2023

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

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

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

Mar 12, 2023

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

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

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

Feb 7, 2023

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 Leading Zeros to Make 10 Digits in Excel (10 Ways)

How to Change Case for Entire Column in Excel (7 Amazing Ways)

Feb 22, 2023

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

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

Feb 9, 2023

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 Change Case in Excel Sheet (8 Quick Methods)

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

Jun 6, 2022

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 Add New Line with CONCATENATE Formula in Excel (5 Ways)

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

Apr 24, 2023

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 Display Day of Week from Date in Excel (8 Ways)

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

Apr 6, 2023

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 Change Lowercase to Uppercase in Excel (6 Methods)

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

Apr 18, 2023

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 of Week in Excel (8 Methods)

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

Feb 26, 2023

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 Convert Date to Day in Excel (7 Quick Ways)

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

May 16, 2023 2

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