Link to home
Start Free TrialLog in
Avatar of brothertruffle880
brothertruffle880Flag for United States of America

asked on

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?
ASKER CERTIFIED SOLUTION
Avatar of aikimark
aikimark
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
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.