Tuesday, 24 July 2012

Excel CONCATENATE Function Syntax and Example

Excel CONCATENATE Function
With Excel Concatenate Function we can Join two or more strings into one string. You can also concatenate Text and Numbers
Syntax:
=CONCATENATE (string1,string2,...)

Str1, Str2, ...   are 2 to 255 items can be joined into a single item. The items can be text strings, numbers, or single-cell references.

Note:
You can also use the ampersand (&) calculation operator instead of the CONCATENATE function to join strings.
Example:


STRING_1
STRING_2
FORMULA
RESULT
Excel
Kingdom
 =CONCATENATE(A2,B2)
ExcelKingdom
Excel
Kingdom
 =A3&B3
ExcelKingdom
USER
123
 =CONCATENATE(A4,B4)
USER123
USER
123
 =A5&B5
USER123
1234
7890
 =CONCATENATE(A6,B6)
12347890
1234
7890
 =A7&B7
12347890
                                             
Thanks.,

TAMATAM


No comments:

Post a Comment

Follow Me by Email

ExcelKingdom-Popular Posts

ExcelKingdom-Random Posts