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
&

e.g.

="First name: "&"Paul"

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

etc.


On 7 Maj, 15:09, paul cardarelli <paul
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
&

& 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
--
If this post helps click Yes
---------------
Jacob Skaria


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

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

Jim Thomlinson


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

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
&