All articles with 'concatenate()' Tag
Excel TEXTJOIN Function – What is it, how to use it & 3 advanced examples
Use TEXTJOIN function to combine text values with optional delimiter. It is better than CONCATENATE because you can pass a range instead of individual cells and you can ignore empty cells too. Here is a sample use of TEXTJOIN Excel function.Continue »
Quickly combine text in multiple cells using this trick! [Formulas]
Ever wondered how to go from a bunch of cells with text to one big combined text? Like shown above.
Well, there is a simple trick. One of our readers, Grant shared this with us. Read on to learn this.Continue »
A Technique for Analysing Large Tables of Data
Once you start using Excel to develop systems, budget, forecast and large tables of data you may come across the dilemma of “How do I know this is right” or “How do I truth check this”.
This post will add a tool to your arsenal to help you out.
Use CTRL+Click to speed up your formula entry [Quick Tips]
Sometimes we think there is very little we can improve in something and then we come across an idea that would change our perceptions. I have been writing excel formulas for such a long time that it was easier to remember when I first shaved than when I first wrote a formula. (may be, because […]Continue »
Excel Links of the Week – Free E-Book Edition
Find out how you can get a free e-book on excel and charting in this week’s excel links.Continue »
What are the formulas you wish Excel had ?
Here is a list of formulas I wish MS Excel had. Alas, we need to build some work-arounds to solve them though.Continue »