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