Excel formula for this...

Discussion in 'Computer Support' started by Max Sand, Sep 2, 2003.

  1. Max Sand

    Max Sand Guest

    Ok i want an excel formula to do this hopefully simple task...

    Say i have cell A1 with the word "dog" in it and cell B2 with the word "Cat"
    in it i want cell H5 to have the data in the previously mentioned cells so
    that it reads "dog, Cat"

    So in english i guess i want multiple cell values in once cell separated by
    a space or a comma or whatever.

    Thanks

    Max
     
    Max Sand, Sep 2, 2003
    #1
    1. Advertising

  2. Max Sand

    Rafael Ortiz Guest

    Try:

    =A1&", "&B2

    MRO

    "Max Sand" <> wrote in message
    news:Yx55b.4433$...
    > Ok i want an excel formula to do this hopefully simple task...
    >
    > Say i have cell A1 with the word "dog" in it and cell B2 with the word

    "Cat"
    > in it i want cell H5 to have the data in the previously mentioned cells so
    > that it reads "dog, Cat"
    >
    > So in english i guess i want multiple cell values in once cell separated

    by
    > a space or a comma or whatever.
    >
    > Thanks
    >
    > Max
    >
    >
     
    Rafael Ortiz, Sep 2, 2003
    #2
    1. Advertising

  3. Max Sand

    Max Sand Guest

    Awsome, i have no idea why i didnt get that - thanks for that MRO

    Max


    "Rafael Ortiz" <> wrote in message
    news:#...
    > Try:
    >
    > =A1&", "&B2
    >
    > MRO
    >
    > "Max Sand" <> wrote in message
    > news:Yx55b.4433$...
    > > Ok i want an excel formula to do this hopefully simple task...
    > >
    > > Say i have cell A1 with the word "dog" in it and cell B2 with the word

    > "Cat"
    > > in it i want cell H5 to have the data in the previously mentioned cells

    so
    > > that it reads "dog, Cat"
    > >
    > > So in english i guess i want multiple cell values in once cell separated

    > by
    > > a space or a comma or whatever.
    > >
    > > Thanks
    > >
    > > Max
    > >
    > >

    >
    >
     
    Max Sand, Sep 2, 2003
    #3
  4. Max Sand

    Bill Guest

    On Tue, 2 Sep 2003 19:44:17 +0100, "Max Sand" <> wrote:

    >Ok i want an excel formula to do this hopefully simple task...
    >
    >Say i have cell A1 with the word "dog" in it and cell B2 with the word "Cat"
    >in it i want cell H5 to have the data in the previously mentioned cells so
    >that it reads "dog, Cat"
    >
    >So in english i guess i want multiple cell values in once cell separated by
    >a space or a comma or whatever.
    >
    >Thanks
    >
    >Max
    >


    In H5 type:
    =concatenate(a1,", ",b2)

    Bill
     
    Bill, Sep 2, 2003
    #4
  5. Max Sand

    why? Guest

    On Tue, 2 Sep 2003 19:44:17 +0100, Max Sand wrote:

    x-post trimmed to 24HSHD from
    24hoursupport.helpdesk,microsoft.public.excel


    >Ok i want an excel formula to do this hopefully simple task...
    >
    >Say i have cell A1 with the word "dog" in it and cell B2 with the word "Cat"
    >in it i want cell H5 to have the data in the previously mentioned cells so
    >that it reads "dog, Cat"
    >
    >So in english i guess i want multiple cell values in once cell separated by
    >a space or a comma or whatever.


    Enter in H5

    =A1 & "," & B2

    & is concatenate string. See the help file.

    So it comes out as , contents of A1 followed by space comma space and
    contents of B2.

    Me
     
    why?, Sep 2, 2003
    #5
  6. Max Sand

    Bill Guest

    On Tue, 2 Sep 2003 19:44:17 +0100, "Max Sand" <> wrote:

    >Ok i want an excel formula to do this hopefully simple task...
    >
    >Say i have cell A1 with the word "dog" in it and cell B2 with the word "Cat"
    >in it i want cell H5 to have the data in the previously mentioned cells so
    >that it reads "dog, Cat"
    >
    >So in english i guess i want multiple cell values in once cell separated by
    >a space or a comma or whatever.
    >
    >Thanks
    >
    >Max
    >


    Or how about:
    =a1&", "&b2

    Bill
     
    Bill, Sep 2, 2003
    #6
  7. Max Sand

    Ed Guest

    "Max Sand" <> wrote in message
    news:_J55b.4445$...
    > Awsome, i have no idea why i didnt get that - thanks for that MRO
    >
    > Max
    >
    >
    > "Rafael Ortiz" <> wrote in message
    > news:#...
    > > Try:
    > >
    > > =A1&", "&B2
    > >
    > > MRO
    > >
    > > "Max Sand" <> wrote in message
    > > news:Yx55b.4433$...
    > > > Ok i want an excel formula to do this hopefully simple task...
    > > >
    > > > Say i have cell A1 with the word "dog" in it and cell B2 with the word

    > > "Cat"
    > > > in it i want cell H5 to have the data in the previously mentioned

    cells
    > so
    > > > that it reads "dog, Cat"
    > > >
    > > > So in english i guess i want multiple cell values in once cell

    separated
    > > by
    > > > a space or a comma or whatever.
    > > >
    > > > Thanks
    > > >
    > > > Max
    > > >
    > > >

    > >
    > >

    >
    >

    After you do this, you may then want to COPY the new column of data (dog,
    cat) then Paste Special... Values into another column... then you can delete
    the original columns "dog" "cat" and "dog, cat"... otherwise you will need
    to hide the individual columns (but if you delete the data then your
    concatenated column will fail).

    Good luck.
     
    Ed, Sep 2, 2003
    #7
    1. Advertising

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Doug

    Excel 2003 Formula

    Doug, Feb 15, 2004, in forum: Microsoft Certification
    Replies:
    0
    Views:
    573
  2. =?Utf-8?B?QyBBbmRlcnNvbg==?=

    Excel Formula

    =?Utf-8?B?QyBBbmRlcnNvbg==?=, Apr 12, 2006, in forum: Microsoft Certification
    Replies:
    1
    Views:
    597
    Carey Frisch [MVP]
    Apr 12, 2006
  3. sunny

    Simple Excel formula required

    sunny, Jan 6, 2004, in forum: Computer Support
    Replies:
    4
    Views:
    710
  4. Katherine Colby

    -Excel Formula Question

    Katherine Colby, Jan 12, 2004, in forum: Computer Support
    Replies:
    3
    Views:
    627
  5. Giuen
    Replies:
    0
    Views:
    1,407
    Giuen
    Sep 12, 2008
Loading...

Share This Page