Excel Tips – Use “&” to Combine String
Here we have a column of First Names and Last Names. We can create a column with Full Names by using &. In Excel, & joins together two or more pieces of text. Don’t forget to put a space between the names. Your formula will look like this;
=[First Name]&” “&[Last Name]
You can mix cell references with actual text as long as the text you want to include is surrounded by quotes.
