Destination Excel: CONCATENATE To Build Addresses


In addition to building names, we often have reason to combine text strings to create full or partial mailing addresses.  Piece o' cake!

As we've already learned this week, we can use the & operator to concatenate any two text strings together.

But that doesn't always make for the prettiest combination... if we just put ampersands between all our terms, the whole thing just comes out as a garble.  What to do?

How about we intersperse commas and spaces in our formula so that the address comes out looking the way we're used to seeing it?

And then from the bottom right corner of that cell, we drag the formula down to populate the remaining cells... beautiful!

Need additional help with CONCATENATE, &, formatting, or other Excel questions?  Start a live chat session with one of our amazing Sherpas today!