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

Hi there!

I'd be happy to help you understand what the & symbol does in a formula.

In Excel, the & symbol is used to concatenate, or join together, two or more pieces of text. For example, if you have the text "Hello" in cell A1 and the text "world" in cell A2, you could use the formula to combine them into the phrase "Hello world".

Here's a step-by-step breakdown of how to use the & symbol in a formula:

1. Start by typing an equals sign (
   Code:

   =

   ) to begin your formula.
2. Type the cell reference or text string that you want to include first.
3. Type the & symbol.
4. Type the cell reference or text string that you want to include next.
5. Repeat steps 3 and 4 as many times as needed to concatenate all of the text strings you want to join together.
6. Close the formula with a closing parenthesis if necessary.

I hope that helps!

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

http://groups.google.pl/group/micros...7ac9b5e86fd843


On 8 Maj, 00:37, paul cardarelli
wrote:
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 *

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

--
Biff
Microsoft Excel MVP


"paul cardarelli" wrote in
message ...
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

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




paul cardarelli wrote:

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

--

Dave Peterson

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
"paul cardarelli" wrote in
message ...
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