How to Concatenate Date and Text in Excel
June 10, 2022
Very often we need to concatenate date and text in Excel. However, this is not as intuitive as you may think. If you simply use the CONCATENATE function, you may end up having something like “44690”. This is because the way Excel see dates is different from how we see dates.
Excel Split Long Text into Short Cell Without Splitting Word
May 10, 2022
I will show you how to split long text into shorter cells without splitting word. This allows you to select the length of the end result.
How to Insert Every Other Row or Every Nth Row
May 3, 2022
I will show you how to insert every other row or every nth row in Excel. I assure you this tutorial will save you lots of effort.
How to Display Blank when Referencing Blank Cell
March 30, 2022
In this article, I will show you how to display blank when referencing blank cell in Excel. I will provide you with 4 ways to achieve the result.
How to Unpivot or Reverse Pivot in Excel
March 22, 2022
In this article, I will show you how to unpivot or reverse pivot data by VBA. I will guide you through how to use the VBA script.
How to Sum the Smallest N Values in Excel
March 22, 2022
Summing is one of the most powerful use of Excel. However, SUM function doesn’t perform all the summing the way we want. For example, when we want to sum the bottom n values in Excel. You can sum those values by using + but it can cost you a few hours if you have a long list to add up.
Categories
.
- Array Formula (3)
- Data validation (3)
- Excel Formula & Functions (34)
- Excel Skills (37)
- Excel Tips and Tricks (38)
- Finance (5)
- Formatting (8)
- Option Pricing (3)
- Pivot table (3)
- Sharing (8)
- Shortcuts (13)
- Solver (1)
- Technical (6)
- VBA (18)
