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

[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
&

 

[Jarek Kujawa]

e.g.

="First name: "&"Paul"

="Length of first name: "&LEN("Paul")

etc.

 

[Jacob Skaria]

& 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

 

[Jim Thomlinson]

The & symbol is the concatenate operator. It is used for joining two strings
together.

 

[Kevin B]

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.