If you want to combine your words using an ampersand and add a space between them, use the formula =CONCATENATE(A3, ” & “, A7). In the photo above, you will see that the texts are joined with ...

The Excel PROPER function is a Text function, and its purpose is to capitalize the first letter in each word of a text. Learn how to use it.

Anti-Concatenate. I have run through how using concatenate for constructing things is great, but it is also useful to know how to deconstruct them from a reporting point of view. I have two main ways ...