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.

You may also like

Leave a comment

This site uses Akismet to reduce spam. Learn how your comment data is processed.