wmfexcel | Work smarter by Mastering Functions in Excel

There are multiple ways to create a list of sequential numbers in Excel. The most common one should be simply type 1 in a cell, followed by drag and drop (fill-series). Another common approach would be using a simple formula of earlier cell + 1. Although...

If you are using #Excel365, you have the privilege of many powerful functions. IMAGE is one of them!
This function works like a charm with just one argument required. Think about a simple formula like this:
It returns the image of the URL you put in cell A1. By default the size of the image returned fits the size of the cell it resides....

Why am I so lazy in blogging in the past year?
If you have been following my blog or YouTube channel, you may have noticed I have been inactive for almost a year… don’t worry about me. I am all good!
Just that I’ve got a new role that occupies most of my time and energy. What’s the role? A picture tells a thousand words…...

A decade ago, I wrote a blog post about the same in an no-formula approach. Ten years has past and Excel has evolved so much. With Excel 365, the same task can be performed in an efficient and effective manner by using TEXTJOIN function. See screenshot...