Excel Forum



Excel Magic Trick # 166: CONCATENATE function & Ampersand


Advantages and disadvantages of the Ampersand symbol and the CONCATENATE function (both join two (2) or more elements together into one text string). Also, see the DOLLAR and TEXT functions.
The Ampersand symbol and the CONCATENATE function both join 2 or more elements together into one text string.
When using the Ampersand (&), you must remember to out Text in Quotes (Double Quotes) and to add an & every time you join something or add something to the text string
The DOLLAR function takes a number and formats it with Currency Number format and converts the number to text.
The TEXT function converts a number to text and applies a number format that you specify





Got a Question? Ask it Here in the Forum.