fbpx
Search
Close this search box.

All articles with 'concatenate()' Tag

Excel TEXTJOIN Function – What is it, how to use it & 3 advanced examples

Published on Jun 9, 2020 in Learn Excel
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]

Published on Jan 13, 2014 in Excel Howtos
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

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.

Continue »

Use CTRL+Click to speed up your formula entry [Quick Tips]

Published on Apr 7, 2010 in Learn Excel
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

Published on Mar 9, 2009 in blogging, excel links

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 ?

Published on Jan 13, 2009 in Featured, Learn Excel

Here is a list of formulas I wish MS Excel had. Alas, we need to build some work-arounds to solve them though.

Continue »