Combine Text Entries in Excel

Excel CONCATENATE Function
© Ted French

Excel's CONCATENATE function can be used to combine data from multiple cells in a spreadsheet.

Names and addresses are often split between two or more cells in an Excel database. Using the CONCATENATE function these can be combined into one cell when needed.

The data can be words, cell references, blank spaces, or numbers.

To find out all the details read this short tutorial on the Excel's CONCATENATE Function.

• Convert Text to Numbers in Excel
• Remove Extra Spaces Between Data in Excel
• Truncate Text Strings in Excel