what does the & symbol do in a formula?

[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 (e-mail address removed)

 

[Jarek Kujawa]

why don't you have a look at at answers to your post in
microsoft.public.excel.misc ?

http://groups.google.pl/group/micro...6d00a/147ac9b5e86fd843?hl=pl#147ac9b5e86fd843

 

[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")

 

[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

 

[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