Use the ampersand (&) to link one value to the next to form a continuous
string.

For example, if cell A1 had the value of $50.00 and you wanted to
concatenate a text prefix and suffix so it said "The Value of $50.00 is in
cell A1." the formula would look like this.

="The Value of "&A1&" is in cell A1."

Note that the literal spaces are always within the quotes, and the ampersand
joining one value to the next does not have any spacing.

Hope this helps.
--
Kevin Backmann
Dallas, TX


"paul cardarelli" wrote:

i am trying to learn the text formulas on excel and have video it used the
& in a formula along with quote marks and text not sure why and when to use
&