what does the & symbol do in a formula?

  • Thread starter paul cardarelli
  • Start date
P

paul cardarelli

need to know what the & symbol does in a formula? am doing a text formula
and watching a tudor video can't understand what it does please write me
direct [email protected]
 
T

T. Valko

It's the concatenation operator.

A1 = try
A2 = this

You could use the CONCATENATE() function like this:

=CONCATENATE(A1," ",A2)

Or, you can use the & operator like this:

=A1&" "&A2

Both return the string: try this

B1 = 10
B2 = 5

C1 = 5

=COUNTIF(B1:B2,">"&C1)

Returns: 1

In this case it's used to concatenate the greater than operator to the cell
value to define the criteria.

=COUNTIF(B1:B2,">5")
 
D

Dave Peterson

It's the concatenation operator:

A formula like:
="Paul" & " " & "Cardarelli"
would return
Paul Cardarelli

If A1 contained a date (say May 7, 2009) and A2 contained a dollar amount (say
1234.12), then

="You owe me: "&text(a2,"$#,##0.00")&". Please pay by: "&text(a1,"mm/dd/yyyy")
would return:
You owe me: $1,234.12. Please pay by: 05/07/2009
 
O

Otto Moehrbach

It simply concatenates. For instance, if you have something in A1 and
something in B1 and you want to have both in one cell with a space between
them, you would write a formula like:
=A1&" "&B1
HTH Otto
 
Top