when do use the & symbol in a text formula, how does it work

  • Thread starter Thread starter paul cardarelli
  • Start date Start date
P

paul cardarelli

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
&
 
& is the alternate of CONCATENATE() function which is used to combine text
values..

A1 = Hi
B1 = Paul
C1 = CONCATENATE(a1," ",b1)

The same can be achieved using
C1 = A1 &" " & B
 
The & symbol is the concatenate operator. It is used for joining two strings
together.
 
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.
 
Back
Top