Say My Name! Building Full Names With CONCATENATE


Work with Excel long enough, and there will come a time when you'll need to build a full name out of partial names.  Surely there must be a formula for that...

In fact there are two!

Suppose we want to create a column called "Full Name."  First we right click on the column heading letter and choose "Insert."

Now it's formula time.  Let's type
=CONCATENATE
and then choose the cells we want to bring together.

Oops, we forgot to include a space!

That's better.  Feels like a big formula for such a simple, commonplace thing... but there's a quicker way!  Excel provides the & operator as a quick way to concatenate strings.

And now we can grab the little "drag button" in the bottom right corner of the cell...

And pull the calculation down to populate the remaining names!

Need more help with CONCATENATE, &, or other Excel questions?  Contact us!

- OR -