|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| |
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" <j.beles@goldkenn.com> wrote in message
> news:3134A313-8D0D-489A-8523-3C6ED4DE8168@microsoft.com...
> >
> >
> > "Stephen" wrote:
> >
> >> "CONCATENATE Excel function" <CONCATENATE Excel
> >> function@discussions.microsoft.com> wrote in message
> >> news:4D6D78EF-8B24-4428-B6DF-C31845D64314@microsoft.com...
> >> >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?
> >>
> >>
>
>
> |
| |
|
| |
Was this post helpful to you? |
|
|
|
|
|
|
|
 Reply |
| |
 |
|
 Top |
|
|
|
|
|
|
|
|
|
| |
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" <j.beles@goldkenn.com> wrote in message
> > news:3134A313-8D0D-489A-8523-3C6ED4DE8168@microsoft.com...
> > >
> > >
> > > "Stephen" wrote:
> > >
> > >> "CONCATENATE Excel function" <CONCATENATE Excel
> > >> function@discussions.microsoft.com> wrote in message
> > >> news:4D6D78EF-8B24-4428-B6DF-C31845D64314@microsoft.com...
> > >> >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
|
| |
|
| |
Was this post helpful to you? |
|
|
|
|
|
|
|
Reply |
| |
|
|
Top |
|
|
|
|
|
|
|
|
|
| |
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" <j.beles@goldkenn.com> wrote in message
> > > news:3134A313-8D0D-489A-8523-3C6ED4DE8168@microsoft.com...
> > > >
> > > >
> > > > "Stephen" wrote:
> > > >
> > > >> "CONCATENATE Excel function" <CONCATENATE Excel
> > > >> function@discussions.microsoft.com> wrote in message
> > > >> news:4D6D78EF-8B24-4428-B6DF-C31845D64314@microsoft.com...
> > > >> >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
> |
| |
|
| |
Was this post helpful to you? |
|
|
|
|
|
|
|
Reply |
| |
|
|
Top |
|
|
|
|
|
|
|
|
|
|
|
Question
Answer
Notify me of replies