How to Unmerge All Cells in Excel?
It is often tempting to combine several related cells of your worksheet into one by merging them together. It could be for aesthetics and alignment or it could be a …
Steve Scott
How to Convert Month Name to Number in Excel?
Converting a date to month name is quite common, but sometimes there may be a need to convert the month name to its corresponding month number. For example, you might …
How to Remove Duplicate Rows based on one Column in Excel?
One of the most common data cleaning tasks in Excel includes removing duplicate or redundant records/rows. While removing whole rows that are duplicate is straightforward, it’s a little trickier when …
Round UP or DOWN to Nearest 5 in Excel (Formula)
We often round numbers up or down to simplify them or make them easier to use. In some cases, we round numbers to a particular integer. There might be situations …
How to Change All Caps to Lowercase Except the First Letter in Excel?
Data that has been imported to Excel from external sources often need to be formatted properly, both for aesthetic as well as functional purposes. If you’ve imported data that contains …
How to Calculate Hours between two Times in Excel?
Calculating the number of hours between two given times might be required for a number of situations. You might need to calculate the number of hours needed to complete a …
How to Convert Decimal to Binary in Excel
If you’re working with computers or machines, you might need to convert a set of decimal numbers into their binary equivalents. In this tutorial we will go over how you …
How to Separate Address in Excel?
When you work with addresses, it can be convenient sometimes to have different parts of the address split out into Street address, city, state, and zip code (or postal code). …
What is the Excel Personal Workbook Location?
The Excel Personal Macro Workbook is the workbook that contains all your created macros in one place. This workbook usually opens whenever you start Excel, but since it is hidden, …
How to Calculate Confidence Interval in Excel
If you want to find out how to calculate a confidence interval in Excel, you’re in the right place! Here, you can see how a confidence interval is calculated based …
Convert Military Time to Standard Time in Excel (Formulas)
A lot of organizations prefer to use the 24-hour ‘military time’. These include the airline industry, public transport, and of course the armed forces. Besides organizations, there are a lot …
How to Bold Text using VBA in Excel
The best way to draw a user’s attention to a cell or some text within a cell is to make it look different from the rest of the text. One …