4] Use the Concatenate function to join and add space and ampersand and another space between words. If you want to combine your words using an ampersand and add a space between them, use the ...

Concatenate merges the data you have inserted into columns into its own cell or column in Excel. Let’s take a look at how to use concatenate in Excel.

If you’re using Excel 2019 through Microsoft 365, there’s a function that can do the same thing, only quicker and with no helper column. How to combine values into a single cell using TEXTJOIN ...