="&, Excel, Word, Access, Powerpoint, Office, Publisher, Visio, Outlook" /> ="& General Discussion" />
If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
">="&
For some of the queries that I have posted, people have very kindly given me the correct formulae to use. Some of these have included & (for example, =countif(A1:A100,"="&date(2004,9,1))-countif(A1:A100,""&date(2004,9,30)). Please could someone tell me what the & actually does and how best to use it? Thank you. -- Angel160 ------------------------------------------------------------------------ Angel160's Profile: http://www.excelforum.com/member.php...o&userid=15503 View this thread: http://www.excelforum.com/showthread...hreadid=276194 |
#2
|
|||
|
|||
Angel160 Wrote: For some of the queries that I have posted, people have very kindly given me the correct formulae to use. Some of these have included & (for example, =countif(A1:A100,"="&date(2004,9,1))-countif(A1:A100,""&date(2004,9,30)). Please could someone tell me what the & actually does and how best to use it? Thank you. The "&" is an operator that joins two items (it is the shortcut version of concatenate). The items can be text strings, numbers or a cell reference. As an example, if cell A1 contains the word "Hello" and Cell B1 contains the word "Dolly" and you would like to join them in Cell C1, then the formula that you will use is =A1&""&B1 Hope this helps you. -- BenjieLop ------------------------------------------------------------------------ BenjieLop's Profile: http://www.excelforum.com/member.php...o&userid=11019 View this thread: http://www.excelforum.com/showthread...hreadid=276194 |
#3
|
|||
|
|||
look up =concatinate in help
The & (ampersand) is a concatinater. -----Original Message----- For some of the queries that I have posted, people have very kindly given me the correct formulae to use. Some of these have included & (for example, =countif(A1:A100,"="&date(2004,9,1))-countif (A1:A100,""&date(2004,9,30)). Please could someone tell me what the & actually does and how best to use it? Thank you. -- Angel160 ---------------------------------------------------------- -------------- Angel160's Profile: http://www.excelforum.com/member.php? action=getinfo&userid=15503 View this thread: http://www.excelforum.com/showthread...hreadid=276194 . |
Thread Tools | |
Display Modes | |
|
|