How to join cell values with CONCATENATE

With the CONCATENATE function, just enter each value you want to join together as a separate argument.

As usual, all “literal text” needs to be surrounded in double quotes.

you’re free to use this trick to quickly add all the arguments you need.

We’ll use the same approach to fix that problem.

By usingIFwithISBLANK, we can test for a middle initial.

As you might see, the CONCATENATE function and the ampersand are both valid options for joining together values.

So, which option should you use?

The choice is entirely your personal preference.

However, the CONCATENATE function also works well and keeps the values you are joining tidy and organized.