youtube SEO, tricks for blogger, wordpress tricks for earning money online youtube earning, whatsapp,windows, android & all about new technology.

Excel Concatenate Formula Example

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.


  • =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.