February 13, 2009, Newsletter Issue #295: Excel´s CONCATENATE function - what does it do?

Tip of the Week

The Excel Concatenate function is used to join several text items into one item.

If cell A1 contains Michael and cell B1 contains Gurner
=concatenate(A1,B1)
Would return MichaelGurner.

To add spaces or other characters between entries, simply enclose them between speech marks (and separate each entry with commas).

In the same example,
=concatenate (A1," ",B1)
would return Michael Gurner

About LifeTips

Now one of the top on-line publishers in the world, LifeTips offers tips to millions of monthly visitors. Our mission mission is to make your life smarter, better, faster and wiser. Expert writers earn dough for what they know. And exclusive sponsors in each niche topic help us make-it-all happen.

Not finding the advice and tips you need on this Software Tip Site? Request a Tip Now!


Guru Spotlight
Jolyn Wells-Moran