Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 326
  • Last Modified:

Excel 2010 - concatenate versus ampersand for cells containing text

What's the difference between using the ampersand and the concatenate function for appending data from various cells?
0
brothertruffle880
Asked:
brothertruffle880
1 Solution
 
aikimarkCommented:
1. Take a look at my Better Concatenate Function article:
https://www.experts-exchange.com/articles/7811/A-Better-Concatenate-Function.html

2. I would expect the & to perform faster than the Concatenate() worksheet function

3. The Concatenate() function has a limit to the number of parameters

4. Cell formulas are limited by the number of characters - Excel version dependent

5. I think that Concatenate() is usually easier to read than & in a cell formula.
0
 
xtermieCommented:
They are equivalent, the one is a function (Concatenate) and the other is an operator (&)
Both have pros and cons like aikimark says, but they basically achieve the same thing.
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now