Better Together: CONCATENATE Function To Merge Text


Peanut butter and jelly.  Nachos and cheese.  First names and last names.  Some things are just better together!

Microsoft Excel gives us a couple of powerful ways to combine text strings in one cell.  One of those ways is the CONCATENATE function.

concat1.JPG

How does it work?  Pretty simple... we start by typing
=CONCATENATE(
and then provide all the text terms that we want to schmush together.

What's the problem with the above example?  We're missing a space!  Not to worry, we simply go back into the formula and add a space text string: " ".

And that's all there is to it!  A simple function, but one of the most versatile and powerful for manipulating text data.  This baby can even be used to convert numbers into text in a jiffy... but more on that later!

Need help with CONCATENATE or other Excel functions?  Just reach out!

- OR -