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.