How to Sort by Length in Excel? (Formula)
When working with Microsoft Excel, you may often come across a situation where you need to sort data based on the length of characters in a cell. For instance, let’s …
Formulas
How to Remove Question Marks from Text in Excel?
If you import data into Excel from other sources, the data may come in with unwanted characters such as question marks. You will need to clean the data by removing …
How to Add a Percentage to a Number in Excel?
In Excel, we often came across a situation where we have to add a percentage to a number. This is often the case when we want to increase or decrease …
How to Separate Date and Time in Excel?
There may be times when you import datasets and find that date and time columns have been combined. In this tutorial, we are going to look at seven simple methods …
How to Change Commas to Decimal Points in Excel?
Countries such as the USA and the UK use a comma to separate groups of thousands and a decimal point to separate decimals. Many other countries such as Spain and …
How to Add Zero In Front of Number in Excel?
If you try to add a leading zero in front of a number in Excel, Excel removes it immediately after you press Enter. This is because a zero before a …
How To Combine Date and Time in Excel?
Sometimes you may have a dataset in Excel that has date and time values in separate columns. You may want to combine those values in one column. In this tutorial, …
How to Get the First Day Of The Month In Excel?
Sometimes, you may want to get the first day of the month when you already have a date. For example, if you have 15 Jan 2023, you can use a …
How to Calculate Year-Over-Year (YOY) Growth in Excel (Formula)
Year Over Year (YOY) growth is a common comparison metric that is considered when analyzing the growth of our business It compares the growth in a certain period of time …
How to Count Unique Values in Excel (Formulas)
Sometimes we may want to know the number of unique values in a dataset. For example, if you have a list of names with repetition, you may want to find …
Calculate Days Between Two Dates in Excel (Workdays/Weekends)
Calculating the number of days between two dates in Excel is a popular operation performed in different scenarios. For example, project managers use it to measure performance against milestones, and …
Remove Middle Name from Full Name in Excel
There may be times when you are given a full name and need to remove the middle name so that you are left with the first and last name only. …