
Pay attention when you concatenate
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.