Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I condense several cells to make address labels?
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I condense several cells to make address labels?
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I condense several cells to make address labels?
"Stephen" wrote: "CONCATENATE Excel function" <CONCATENATE Excel wrote in message ... 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? CONCATENATE simply joins the text from two (or more) cells. For example, with "qwe" in A1 and "rty" in B1, =CONCATENATE(A1,B1) will give "qwerty". However, it's a redundant function since the much simler formula =A1&B1 does the same thing. 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? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I condense several cells to make address labels?
Hi
It should show up immediately - if you have calculation set to Automatic (see Tools/Options/Calculation) Andy. "Jen" wrote in message ... "Stephen" wrote: "CONCATENATE Excel function" <CONCATENATE Excel wrote in message ... 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? CONCATENATE simply joins the text from two (or more) cells. For example, with "qwe" in A1 and "rty" in B1, =CONCATENATE(A1,B1) will give "qwerty". However, it's a redundant function since the much simler formula =A1&B1 does the same thing. 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? |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I condense several cells to make address labels?
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 & on a French keyboard & system, so am not sure that CHAR is the same in French...any ideas???? "Andy" wrote: Hi It should show up immediately - if you have calculation set to Automatic (see Tools/Options/Calculation) Andy. "Jen" wrote in message ... "Stephen" wrote: "CONCATENATE Excel function" <CONCATENATE Excel wrote in message ... 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? CONCATENATE simply joins the text from two (or more) cells. For example, with "qwe" in A1 and "rty" in B1, =CONCATENATE(A1,B1) will give "qwerty". However, it's a redundant function since the much simler formula =A1&B1 does the same thing. 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? |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I condense several cells to make address labels?
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 = "=char(10)" 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: 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 & on a French keyboard & system, so am not sure that CHAR is the same in French...any ideas???? "Andy" wrote: Hi It should show up immediately - if you have calculation set to Automatic (see Tools/Options/Calculation) Andy. "Jen" wrote in message ... "Stephen" wrote: "CONCATENATE Excel function" <CONCATENATE Excel wrote in message ... 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? CONCATENATE simply joins the text from two (or more) cells. For example, with "qwe" in A1 and "rty" in B1, =CONCATENATE(A1,B1) will give "qwerty". However, it's a redundant function since the much simler formula =A1&B1 does the same thing. 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? -- Dave Peterson |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I condense several cells to make address labels?
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, "CONCATENATE Excel function" <CONCATENATE Excel wrote: 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? |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I condense several cells to make address labels?
Thanks a million Dave!!!!!!!!!!!!!!!!!!!!!
:-)))))))))) "Dave Peterson" wrote: 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 = "=char(10)" 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: 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 & on a French keyboard & system, so am not sure that CHAR is the same in French...any ideas???? "Andy" wrote: Hi It should show up immediately - if you have calculation set to Automatic (see Tools/Options/Calculation) Andy. "Jen" wrote in message ... "Stephen" wrote: "CONCATENATE Excel function" <CONCATENATE Excel wrote in message ... 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? CONCATENATE simply joins the text from two (or more) cells. For example, with "qwe" in A1 and "rty" in B1, =CONCATENATE(A1,B1) will give "qwerty". However, it's a redundant function since the much simler formula =A1&B1 does the same thing. 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? -- Dave Peterson |
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I condense several cells to make address labels?
Thank you for the clarification...:-)
"Gord Dibben" wrote: 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, "CONCATENATE Excel function" <CONCATENATE Excel wrote: 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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I change a text to a cell's address? | Excel Discussion (Misc queries) | |||
How do I merge cells in Excel, like just 2 cells to make one big . | Excel Discussion (Misc queries) | |||
Make pictures go behind cells. | Excel Discussion (Misc queries) | |||
how do I make make my hyperlinks show the email address they are . | Excel Discussion (Misc queries) | |||
How do I make mailing labels from an excel document? | Setting up and Configuration of Excel |