software

I cannot seem to figure out the CONCATENATE function. I have an enormous
amount of info. on a spreadsheet, from which I would like to extrapolate
information to make a address label database. How do I do this?

quot;CONCATENATE Excel functionquot; lt;CONCATENATE Excel
gt; wrote in message
...
gt;I cannot seem to figure out the CONCATENATE function. I have an enormous
gt; amount of info. on a spreadsheet, from which I would like to extrapolate
gt; information to make a address label database. How do I do this?

CONCATENATE simply joins the text from two (or more) cells. For example,
with quot;qwequot; in A1 and quot;rtyquot; in B1,
=CONCATENATE(A1,B1)
will give quot;qwertyquot;.
However, it's a redundant function since the much simler formula
=A1amp;B1
does the same thing.


quot;Stephenquot; wrote:

gt; quot;CONCATENATE Excel functionquot; lt;CONCATENATE Excel
gt; gt; wrote in message
gt; ...
gt; gt;I cannot seem to figure out the CONCATENATE function. I have an enormous
gt; gt; amount of info. on a spreadsheet, from which I would like to extrapolate
gt; gt; information to make a address label database. How do I do this?
gt;
gt; CONCATENATE simply joins the text from two (or more) cells. For example,
gt; with quot;qwequot; in A1 and quot;rtyquot; in B1,
gt; =CONCATENATE(A1,B1)
gt; will give quot;qwertyquot;.
gt; However, it's a redundant function since the much simler formula
gt; =A1amp;B1
gt; does the same thing.
gt;
Thank you very much..it's the first time I use this function:-)))
Just one more question, does the result of this formula show up right away
or do I have to do soemthing else?
gt;
gt;

Hi

It should show up immediately - if you have calculation set to Automatic
(see Tools/Options/Calculation)

Andy.

quot;Jenquot; gt; wrote in message
...
gt;
gt;
gt; quot;Stephenquot; wrote:
gt;
gt;gt; quot;CONCATENATE Excel functionquot; lt;CONCATENATE Excel
gt;gt; gt; wrote in message
gt;gt; ...
gt;gt; gt;I cannot seem to figure out the CONCATENATE function. I have an enormous
gt;gt; gt; amount of info. on a spreadsheet, from which I would like to
gt;gt; gt; extrapolate
gt;gt; gt; information to make a address label database. How do I do this?
gt;gt;
gt;gt; CONCATENATE simply joins the text from two (or more) cells. For example,
gt;gt; with quot;qwequot; in A1 and quot;rtyquot; in B1,
gt;gt; =CONCATENATE(A1,B1)
gt;gt; will give quot;qwertyquot;.
gt;gt; However, it's a redundant function since the much simler formula
gt;gt; =A1amp;B1
gt;gt; does the same thing.
gt;gt;
gt; Thank you very much..it's the first time I use this function:-)))
gt; Just one more question, does the result of this formula show up right away
gt; or do I have to do soemthing else?
gt;gt;
gt;gt;
Hi Andy,

Thanks for the info. It works now, but I am having a hard time getting one
cell to go underneath the other..I used the CHAR(10), but am working from
Switz amp; on a French keyboard amp; system, so am not sure that CHAR is the same
in French...any ideas????

quot;Andyquot; wrote:

gt; Hi
gt;
gt; It should show up immediately - if you have calculation set to Automatic
gt; (see Tools/Options/Calculation)
gt;
gt; Andy.
gt;
gt; quot;Jenquot; gt; wrote in message
gt; ...
gt; gt;
gt; gt;
gt; gt; quot;Stephenquot; wrote:
gt; gt;
gt; gt;gt; quot;CONCATENATE Excel functionquot; lt;CONCATENATE Excel
gt; gt;gt; gt; wrote in message
gt; gt;gt; ...
gt; gt;gt; gt;I cannot seem to figure out the CONCATENATE function. I have an enormous
gt; gt;gt; gt; amount of info. on a spreadsheet, from which I would like to
gt; gt;gt; gt; extrapolate
gt; gt;gt; gt; information to make a address label database. How do I do this?
gt; gt;gt;
gt; gt;gt; CONCATENATE simply joins the text from two (or more) cells. For example,
gt; gt;gt; with quot;qwequot; in A1 and quot;rtyquot; in B1,
gt; gt;gt; =CONCATENATE(A1,B1)
gt; gt;gt; will give quot;qwertyquot;.
gt; gt;gt; However, it's a redundant function since the much simler formula
gt; gt;gt; =A1amp;B1
gt; gt;gt; does the same thing.
gt; gt;gt;
gt; gt; Thank you very much..it's the first time I use this function:-)))
gt; gt; Just one more question, does the result of this formula show up right away
gt; gt; or do I have to do soemthing else?
gt; gt;gt;
gt; gt;gt;
gt;
gt;
gt;

Select an empty cell
then hit alt-f11 (to see the VBE, where macros live)
then hit ctrl-g (to see the immediate window)

Type this and hit enter:
activecell.formula = quot;=char(10)quot;

Then back to excel and look at the formula bar with that cell still selected.
(Excel will translate the VBA code for you.)
Jen wrote:
gt;
gt; Hi Andy,
gt;
gt; Thanks for the info. It works now, but I am having a hard time getting one
gt; cell to go underneath the other..I used the CHAR(10), but am working from
gt; Switz amp; on a French keyboard amp; system, so am not sure that CHAR is the same
gt; in French...any ideas????
gt;
gt; quot;Andyquot; wrote:
gt;
gt; gt; Hi
gt; gt;
gt; gt; It should show up immediately - if you have calculation set to Automatic
gt; gt; (see Tools/Options/Calculation)
gt; gt;
gt; gt; Andy.
gt; gt;
gt; gt; quot;Jenquot; gt; wrote in message
gt; gt; ...
gt; gt; gt;
gt; gt; gt;
gt; gt; gt; quot;Stephenquot; wrote:
gt; gt; gt;
gt; gt; gt;gt; quot;CONCATENATE Excel functionquot; lt;CONCATENATE Excel
gt; gt; gt;gt; gt; wrote in message
gt; gt; gt;gt; ...
gt; gt; gt;gt; gt;I cannot seem to figure out the CONCATENATE function. I have an enormous
gt; gt; gt;gt; gt; amount of info. on a spreadsheet, from which I would like to
gt; gt; gt;gt; gt; extrapolate
gt; gt; gt;gt; gt; information to make a address label database. How do I do this?
gt; gt; gt;gt;
gt; gt; gt;gt; CONCATENATE simply joins the text from two (or more) cells. For example,
gt; gt; gt;gt; with quot;qwequot; in A1 and quot;rtyquot; in B1,
gt; gt; gt;gt; =CONCATENATE(A1,B1)
gt; gt; gt;gt; will give quot;qwertyquot;.
gt; gt; gt;gt; However, it's a redundant function since the much simler formula
gt; gt; gt;gt; =A1amp;B1
gt; gt; gt;gt; does the same thing.
gt; gt; gt;gt;
gt; gt; gt; Thank you very much..it's the first time I use this function:-)))
gt; gt; gt; Just one more question, does the result of this formula show up right away
gt; gt; gt; or do I have to do soemthing else?
gt; gt; gt;gt;
gt; gt; gt;gt;
gt; gt;
gt; gt;
gt; gt;

--

Dave Peterson

Just for info.

Most labelling programs like the data to be in separate columns, not all in
one.

i.e. if you were to use Word for making the labels with Excel as the data
source you would need the data in separate columns. Each record on its own
row.Gord Dibben Excel MVP

On Wed, 14 Dec 2005 03:27:02 -0800, quot;CONCATENATE Excel functionquot; lt;CONCATENATE
Excel gt; wrote:

gt;I cannot seem to figure out the CONCATENATE function. I have an enormous
gt;amount of info. on a spreadsheet, from which I would like to extrapolate
gt;information to make a address label database. How do I do this?

Thanks a million Dave!!!!!!!!!!!!!!!!!!!!!
:-))))))))))

quot;Dave Petersonquot; wrote:

gt; Select an empty cell
gt; then hit alt-f11 (to see the VBE, where macros live)
gt; then hit ctrl-g (to see the immediate window)
gt;
gt; Type this and hit enter:
gt; activecell.formula = quot;=char(10)quot;
gt;
gt; Then back to excel and look at the formula bar with that cell still selected.
gt; (Excel will translate the VBA code for you.)
gt;
gt;
gt;
gt; Jen wrote:
gt; gt;
gt; gt; Hi Andy,
gt; gt;
gt; gt; Thanks for the info. It works now, but I am having a hard time getting one
gt; gt; cell to go underneath the other..I used the CHAR(10), but am working from
gt; gt; Switz amp; on a French keyboard amp; system, so am not sure that CHAR is the same
gt; gt; in French...any ideas????
gt; gt;
gt; gt; quot;Andyquot; wrote:
gt; gt;
gt; gt; gt; Hi
gt; gt; gt;
gt; gt; gt; It should show up immediately - if you have calculation set to Automatic
gt; gt; gt; (see Tools/Options/Calculation)
gt; gt; gt;
gt; gt; gt; Andy.
gt; gt; gt;
gt; gt; gt; quot;Jenquot; gt; wrote in message
gt; gt; gt; ...
gt; gt; gt; gt;
gt; gt; gt; gt;
gt; gt; gt; gt; quot;Stephenquot; wrote:
gt; gt; gt; gt;
gt; gt; gt; gt;gt; quot;CONCATENATE Excel functionquot; lt;CONCATENATE Excel
gt; gt; gt; gt;gt; gt; wrote in message
gt; gt; gt; gt;gt; ...
gt; gt; gt; gt;gt; gt;I cannot seem to figure out the CONCATENATE function. I have an enormous
gt; gt; gt; gt;gt; gt; amount of info. on a spreadsheet, from which I would like to
gt; gt; gt; gt;gt; gt; extrapolate
gt; gt; gt; gt;gt; gt; information to make a address label database. How do I do this?
gt; gt; gt; gt;gt;
gt; gt; gt; gt;gt; CONCATENATE simply joins the text from two (or more) cells. For example,
gt; gt; gt; gt;gt; with quot;qwequot; in A1 and quot;rtyquot; in B1,
gt; gt; gt; gt;gt; =CONCATENATE(A1,B1)
gt; gt; gt; gt;gt; will give quot;qwertyquot;.
gt; gt; gt; gt;gt; However, it's a redundant function since the much simler formula
gt; gt; gt; gt;gt; =A1amp;B1
gt; gt; gt; gt;gt; does the same thing.
gt; gt; gt; gt;gt;
gt; gt; gt; gt; Thank you very much..it's the first time I use this function:-)))
gt; gt; gt; gt; Just one more question, does the result of this formula show up right away
gt; gt; gt; gt; or do I have to do soemthing else?
gt; gt; gt; gt;gt;
gt; gt; gt; gt;gt;
gt; gt; gt;
gt; gt; gt;
gt; gt; gt;
gt;
gt; --
gt;
gt; Dave Peterson
gt;

Thank you for the clarification...:-)

quot;Gord Dibbenquot; wrote:

gt; Just for info.
gt;
gt; Most labelling programs like the data to be in separate columns, not all in
gt; one.
gt;
gt; i.e. if you were to use Word for making the labels with Excel as the data
gt; source you would need the data in separate columns. Each record on its own
gt; row.
gt;
gt;
gt; Gord Dibben Excel MVP
gt;
gt; On Wed, 14 Dec 2005 03:27:02 -0800, quot;CONCATENATE Excel functionquot; lt;CONCATENATE
gt; Excel gt; wrote:
gt;
gt; gt;I cannot seem to figure out the CONCATENATE function. I have an enormous
gt; gt;amount of info. on a spreadsheet, from which I would like to extrapolate
gt; gt;information to make a address label database. How do I do this?
gt;