Joins together multiple text strings or cell values into one string.
=CONCATENATE("Sales: ", B1) might produce "Sales: 100" if B1 contains 100.
