Excel Concatenate Formula Example

May 12, 2015 Excel Formulas No comments

Combine excel sheet cells value by using Concatenate Function

What Does It Do?

This function joins separate pieces of text into one item.

Syntax

=CONCATENATE(Text1,Text2,Text3...Text30) Up to thirty pieces of text can be joined.

Formatting

No special formatting is needed, the result will be shown as normal text.

Note

You can achieve the same result by using the & operator.

Subscribe to: Post Comments ( Atom )