21 February 2015
In many case, we may want to combine texts from different cells. This can be done by either CONCATENATE function or simply an ampersand &.
If you are doing so because you want to perform VLOOKUP with 2 lookup values, the robust way to combine texts should include a delimiter in between, e.g. A1 & "|" & B1.
Why? Because laziness has a price.
Full article: Pay attention when you concatenate
