How to Remove the Last Digit in Excel?
When cleaning data in Excel, you will often come across situations where you need to remove the last digit from the data. If you only have a few data entries …
Formulas
#NUM! Error in Excel – How to Fix it?
We are all visited by the unwelcome #NUM! error in our Excel worksheets from time to time. What’s annoying about the #NUM! error in Excel is that the error message does …
How to Remove Year from Date in Excel?
There are times when you may need to remove the year component from a date in Excel. For example, before you send the list of company employees’ birth dates to …
How to Sort by Length in Excel? Easy 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 …
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 (7 Easy Ways)
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? 5 Easy Ways!
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 (7 Easy Ways)
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 (3 Easy Ways)
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? (3 Easy Formulas)
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 …