software

Would someone explain to me in plain english what quot;concatenatequot; means? Thank
you for explaining this to me.

basically, it means quot;to joinquot; - it allows you to merge teh contents of cells
so you can have more easily understood information.

con·cat·e·nate ( P ) Pronunciation Key (kn-ktn-t, kn-)
tr.v. con·cat·e·nat·ed, con·cat·e·nat·ing, con·cat·e·nates
To connect or link in a series or chain.
Computer Science. To arrange (strings of characters) into a chained list.

Mark

quot;countrygirl0712quot; wrote:

gt; Would someone explain to me in plain english what quot;concatenatequot; means? Thank
gt; you for explaining this to me.


quot;countrygirl0712quot; gt; wrote in
message ...
gt; Would someone explain to me in plain english what quot;concatenatequot; means?
gt; Thank
gt; you for explaining this to me.

Main Entry: concatenate
Pronunciation: -quot;nAt
Function: transitive verb
Inflected Form(s): -nat�ed; -nat�ing
: to link together in a series or chain

In Excel, the function can take bits of text from different cells and chain
them together to make longer text, sentences, etc.
CONCATENATE means to join multiple strings together to form one long string.

Example:
A1John
A2Smith
A3=CONCATENATE(A2,quot;, quot;,A2)

A3 equals quot;Smith, Johnquot; which is the combination of three text strings
quot;Smithquot;, quot;, quot; and quot;Johnquot;.

It is better to use amp; to join text strings

Example:
A3=A2amp;quot;, quot;amp;A1

quot;countrygirl0712quot; wrote:

gt; Would someone explain to me in plain english what quot;concatenatequot; means? Thank
gt; you for explaining this to me.

quot;Slothquot; gt; wrote in message
...
gt; CONCATENATE means to join multiple strings together to form one long
gt; string.
gt;
gt; Example:
gt; A1 John
gt; A2 Smith
gt; A3 =CONCATENATE(A2,quot;, quot;,A2)
gt;
gt; A3 equals quot;Smith, Johnquot; which is the combination of three text strings
gt; quot;Smithquot;, quot;, quot; and quot;Johnquot;.
gt;
gt; It is better to use amp; to join text strings

Why is that method better?
In my opinion...

it is more efficient (11 less charectors to type)
it is simple to type (you can't mispel it)
it is easier to understand (to me anyway)

although I geuss it is up to debate which method is better, and I should
have said quot;You can also use the ampersand (amp;) to join strings together.quot;
instead.

quot;Doug Kanterquot; wrote:

gt; quot;Slothquot; gt; wrote in message
gt; ...
gt; gt; CONCATENATE means to join multiple strings together to form one long
gt; gt; string.
gt; gt;
gt; gt; Example:
gt; gt; A1 John
gt; gt; A2 Smith
gt; gt; A3 =CONCATENATE(A2,quot;, quot;,A2)
gt; gt;
gt; gt; A3 equals quot;Smith, Johnquot; which is the combination of three text strings
gt; gt; quot;Smithquot;, quot;, quot; and quot;Johnquot;.
gt; gt;
gt; gt; It is better to use amp; to join text strings
gt;
gt; Why is that method better?
gt;
gt;
gt;

I was wondering that, too. Why not just use Excel's quot;amp;quot; to combine the
cells:

= A1 amp; quot;, quot; amp; A2Ron M.I just wondered if one method had more options available than the other. I
suppose using CONCATENATE() might make for more easily readable formulae, if
they need to be understandable to someone who didn't create the sheet.

quot;Slothquot; gt; wrote in message
...
gt; In my opinion...
gt;
gt; it is more efficient (11 less charectors to type)
gt; it is simple to type (you can't mispel it)
gt; it is easier to understand (to me anyway)
gt;
gt; although I geuss it is up to debate which method is better, and I should
gt; have said quot;You can also use the ampersand (amp;) to join strings together.quot;
gt; instead.
gt;
gt; quot;Doug Kanterquot; wrote:
gt;
gt;gt; quot;Slothquot; gt; wrote in message
gt;gt; ...
gt;gt; gt; CONCATENATE means to join multiple strings together to form one long
gt;gt; gt; string.
gt;gt; gt;
gt;gt; gt; Example:
gt;gt; gt; A1 John
gt;gt; gt; A2 Smith
gt;gt; gt; A3 =CONCATENATE(A2,quot;, quot;,A2)
gt;gt; gt;
gt;gt; gt; A3 equals quot;Smith, Johnquot; which is the combination of three text strings
gt;gt; gt; quot;Smithquot;, quot;, quot; and quot;Johnquot;.
gt;gt; gt;
gt;gt; gt; It is better to use amp; to join text strings
gt;gt;
gt;gt; Why is that method better?
gt;gt;
gt;gt;
gt;gt;