Let’s discuss ways to convert values from positives to negatives and vice versa by using Paste Special, Find and Replace, ABS Function and Custom Formatting. Let’s begin with Paste Special technique. 1. Paste Special Technique The function name itself says that it is special. The reason why it is so special is that it can […]
How to Split Text Data of a Cell to Column in Excel
In our previous post “10 Basic Excel Functions That Everyone Should Know” we learned how to use the =CONCATENATE() function. Concatenate merges data of different cells into one cell. What if I want to split the data of a cell into multiple cells or in other words how to reverse the concatenate function? For example, I […]
How to Change 5 Digit General Numbers to Date Format in Excel
It sometimes happens that we type or copy/paste date formats from sheets in Excel, but it displays as number. Let’s convert those 5-digits general numbers to date format with 2 easy steps using default date formatting function. For example, we copied date from external source or wrote date in the cell but it displays in […]
How to use AND, OR and NOT Functions in MS Excel
Just like the IF function that we learned in our previous article “10-basic-excel-functions-everyone-know”, the AND, OR and NOT functions are logical functions in Excel. These functions are used for logical comparisons in IF function. 1. AND and OR Functions We can add up to 30 arguments in these functions. Let us discuss some difference between […]
How To Calculate Year, Month and Day In A Given Number
Let me show you how to convert the number of days to year/month/day in the prescribed format “1 year 4 months 25days” in Excel. Convert number of Days to year/month/day format For this, we need to use the DATEDIF function. Syntax for DATEDIF Function: DATEDIF(start_date,end_date,unit) First of all select a blank cell you where we […]