Excel 2007 CONCATENATE Function

Excel's CONCATENATE function can be used to join together data from two or more cells in a spreadsheet.

For example, it can be used to combine data from a number of fields in a database. 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 the details of using this function in your read the article on the Excel 2007 CONCATENATE Function.

Related Articles

• Excel 2007 LEFT Function
• Excel 2007 REPLACE Function
• Excel 2007 TRIM Function