+ Reply to Thread
Results 1 to 5 of 5

Concatinate the text of each row

  1. #1
    Registered User
    Join Date
    05-29-2012
    Location
    excelforum
    MS-Off Ver
    Excel 2003
    Posts
    4

    Unhappy Concatinate the text of each row

    Good day!
    I'm new to excel and I'm trying to concatenate the text in 3 cells and print in the 4th cell

    col1(A) col2(B) col3 (C) col4 (D)
    ====================================
    text1 text2 text3 text1+text2+text3
    text2 text3 text4 text2+text3+text4
    text5 text6 text7 text5+text6+text7
    -- -- --
    -- -- --

    There are more than 100 rows

    I can use this function for each row
    =CONCATENATE(A1,B1,C1) and print the result in D1 cell

    again I go to the next row
    =CONCATENATE(A2,B2,C2) and print the result in D2 cell

    I want to select the entire D column and fill each D column cells without going into each D cells and apply the function

    Could somebody please help me?

    Thank you!
    Last edited by dumiduw; 05-29-2012 at 06:49 AM.

  2. #2
    Registered User
    Join Date
    05-07-2012
    Location
    pune
    MS-Off Ver
    Excel 2007
    Posts
    57

    Re: Concatinate the text of each row

    can u please attached the sample file and output file how it would be displayed

  3. #3
    Forum Expert
    Join Date
    07-16-2010
    Location
    Northumberland, UK
    MS-Off Ver
    Excel 2007 (home), Excel 2010 (work)
    Posts
    3,054

    Re: Concatinate the text of each row

    Enter your formula in cell D1, there'll be a little black square in the bottom right hand corner of cell D1 - double-click on this and it will copy your formula down to the end of the data.
    Last edited by Andrew-R; 05-29-2012 at 06:52 AM. Reason: D'oh!

  4. #4
    Forum Expert icestationzbra's Avatar
    Join Date
    01-07-2004
    MS-Off Ver
    2007, 2010
    Posts
    1,417

    Re: Concatinate the text of each row

    based on the assumption that i have understood your requirement correctly, following are some suggestions:

    the CONCATENATE function can also be achieved with the '&'.

    so, in D1, you can simply put =a1&b1&c1

    and then drag-fill this formula down to as many rows as you want; you will not have to keep entering the formula in every cell along column D.

    the same is true for the CONCATENATE formula you have written; enter it once and drag-fill down.

    you can also double-click on the drag-fill handle (black square at right-bottom) to have the formula auto-populate along column D until the row where first blank is found in the adjacent column C.

    alternately, you can select the entire column D by clicking on the letter 'D' (you will observe that D1 is white, rest of the column is highlighted). hit F2, then enter your formula (either the CONCATENATE or the &), which will appear in D1. then confirm with CTRL+ENTER.
    - i.s.z -
    CSE, aka Array aka { }, formulae are confirmed with CONTROL+SHIFT+ENTER.
    Replace commas ( , ) with semicolons ( ; ) in formulae, if your locale setting demands.
    All good ideas are courtesy resources from this forum as well as others around the web.
    - e.o.m -

  5. #5
    Registered User
    Join Date
    05-29-2012
    Location
    excelforum
    MS-Off Ver
    Excel 2003
    Posts
    4

    Re: Concatinate the text of each row

    @icestationzbra thank you so much! it worked

    Thank you all people participated to help me.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1