Subscribe!

The Excel concatenate function can be used to combine multiple cells into one.

Syntax

CONCATENATE (text1,text2,…)

Text1, text2, are items to be joined into a single text item. The text items can be text strings, numbers, or single-cell references. Real world example:

Cell A1 contains: I
Cell A2 contains: Love
Cell A3 contains: Concatenate

Type =concatenate(a1,a2,a3) in A4

The result in A4 would be: ILoveConcatenate

Note:
The “&” operator can be used instead of Concatenate to join text items.

Joseph Harris
ExcelYogi.com
Analyst Resources

Related posts:

  1. Excel CELL () Function The CELL function can be used to find out information...

This entry was posted on Thursday, November 20th, 2008 at 10:12 am and is filed under Functions. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.

Leave a Reply

You must be logged in to post a comment.