Actually it normally refers to concatenation. & identifies values as
text strings and simply adds (concatenates) the two values into one
longer string. Thus a value in D1 of 45 and a value in E1 of 23, and a
formula pointing to these cells such as =(D1&E1) returns a text string
of 4523. I use numerals to point out that concatenation identifies these
as text strings. Similarly a cell value "Cost"and another "price" when
concatenated become Costprice.
Usefulness? Not sure!!
W
Joe Conner wrote:
It means multiplication.
Paul Smith wrote:
Dear All
I have seen formulae that include the ampersand symbol. However, I
cannot find any documentation about that symbol in the Calc's help.
Could someone please point to a place where I could learn what for is
the ampersand designed?
Thanks in advance,
Paul
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
--
Remove INVALID from my Reply-To address
Reclaim Your Inbox!
http://www.mozilla.org/products/thunderbird
The Browser you can trust
Get Firefox! <http://www.spreadfirefox.com/?q=affiliates&id=128255&t=1>
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
