You can use the Excel Concatenate function to create a sentence, join and add space between words, comma between words, space between words, etc.

Adding a text to a cell in Excel using Formula requires use of ampersand operator, CONCAT function, or the LEFT, RIGHT, and LEN functions.

How to combine values into a single cell in .xls Excel files The newer features and functions that I’ll be using later in this article aren’t available in the earlier .xls format.

Use Delimiters in Excel One of the most straightforward ways to separate first and last names is by using delimiters in Excel. A delimiter is a character that separates different parts of text data.

When you want to combine values in Microsoft Excel, instead of complex expressions or VBA, opt for Power Query – it’s fast and easy.