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.


How does it work?  Pretty simple... we start by typing
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 -