TEXT Function

How to Calculate Time Difference in Excel Between Two Dates (7 Ways)

In this article, you will learn 7 quick ways to calculate the time difference in Excel between two dates. Download Practice Workbook You can ...

Split Date and Time Column in Excel (7 Easy Methods)

If you have a date and time in the same cell and need to separate them into two different columns, you are in right place! In this article, I will ...

How to Separate Date in Excel Using Formula (5 Suitable Ways)

Separating dates from different parts of the text or time is one of the most common uses of Excel.  Also extracting day month and year from part of ...

How to Split Date and Time in Excel (8 Easy Methods)

If you are looking for some special tricks to split date and time in Excel, you've come to the right place. In Microsoft Excel, there are numerous ...

How to Separate Date and Time Using Formula in Excel (4 Easy Ways)

  Excel has the ability to handle several types of data. Beyond them, time and date are most common. Besides them, Excel has completely ...

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 Generate Random Date and Time in Excel (3 Ways)

For many demonstration or experimental purposes, you may want to fill up Excel columns with random dates and times. You of course can fill those ...

How to Insert Date in Excel Formula (8 Ways)

Excel can store date values as a different category of its own. Dates starting from 1st January 1990 follows this pattern. You can write dates ...

How to Insert Day and Date in Excel (3 Ways)

Often in workplaces or in other many reasons we need to encounter dates. Dates are quite common in our daily Excel workflow. From tracking down ...

How to Remove Percentage Symbol in Excel (4 Ways)

For many practical reasons, one might need to remove the percentage symbol from the number string. The answer to the question “How to remove ...

How to Add Dashes to SSN in Excel (6 Methods)

Microsoft Excel offers multiple ways to add dashes to the social security numbers (SSNs). You can use formulas or Format Cells dialog box to add ...

How to Extract Year from Date in Excel (3 Ways)

When you have a large set of data with dates and you want to extract only years from data, Excel gives you every opportunity to do it. Mind it, you ...

How to Split Data in Excel (5 Ways)

In different circumstances, we need to split our data into different pieces. These dissections of data are usually done by space, commas, or some ...

How to Write Phone Number in Excel (Every Possible Way)

Usually, Excel treats phone numbers as just another number entered in a cell unless we modify it or write it manually otherwise. Entering each phone ...

How to Format Phone Number with Dashes in Excel (2 Ways)

Sometimes we need to deal with datasets packed with random phone numbers without formatting. Using and understanding those phone numbers is difficult ...

ExcelDemy
Logo