+ Reply to Thread
Results 1 to 5 of 5

How can I combine data from 3 columns into one?

  1. #1
    Registered User
    Join Date
    03-09-2009
    Location
    Colorado
    MS-Off Ver
    Excel 2003
    Posts
    4

    How can I combine data from 3 columns into one?

    I receive a tab delimited data file from my manufacturer which I place into an Excel file. The data file has the product description separated into 3 columns.
    (description 1, description 2, description 3)
    I want to have all the text combined to form just one description column. I would like to have a blank line between description 1 & 2 and also 2 & 3.

    Is there a slick way to do this, as I have hundreds of products that I need to combine the descriptions for, and doing this manually one at a time would take darn near forever.

    Thanks!

  2. #2
    Forum Guru teylyn's Avatar
    Join Date
    10-28-2008
    Location
    New Zealand
    MS-Off Ver
    Excel 365 Insider Fast
    Posts
    11,364

    Re: How can I combine data from 3 columns into one?

    Hi,

    you can insert a new column and put in a formula along the lines of

    =A1&CHAR(10)&CHAR(10)&B1&CHAR(10)&CHAR(10)&C1

    Char(10) enters a line break, just like hitting ALT-Enter when editing a cell.
    Make sure that you format the cells to wrap the text (Format cell - Alignment tab), otherwise you may see no line break, but a little box for each Char(10)

    If you want to delete the original three columns, you'll need to copy the new column first and then paste it onto itself with Paste Special - Values. Or, you could simply hide the columns with the original text.

    Does that help?

  3. #3
    Registered User
    Join Date
    06-28-2007
    Posts
    69

    Re: How can I combine data from 3 columns into one?

    =a1&" "&b1&" "&c1

  4. #4
    Registered User
    Join Date
    03-09-2009
    Location
    Colorado
    MS-Off Ver
    Excel 2003
    Posts
    4

    Re: How can I combine data from 3 columns into one?

    Hey Teylyn,

    Yes, I tried that and it combines the columns just fine.

    Now, I take this Excel file and import it into another data base program
    that is expecting to see a regular tab delimited file. Is is necessary to
    add the cell formatting that you showed, or can I just leave the cells
    as is... when looking at it, the line break appears as = = . Will this
    be interpreted as a line break with my other program?

    Also, I see that columns can be combined using =a1&" "&b1&" "&c1

    Is there a character for line break, or line feed that can be
    placed between the quotes that will make this formula work the same way?

    Thanks a bunch.

  5. #5
    Administrator JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: How can I combine data from 3 columns into one?

    Perhaps something like this:

    =A1&" "&B1&CHAR(13)&C1
    _________________
    Microsoft MVP 2010 - Excel
    Visit: Jerry Beaucaire's Excel Files & Macros

    If you've been given good help, use the icon below to give reputation feedback, it is appreciated.
    Always put your code between code tags. [CODE] your code here [/CODE]

    “None of us is as good as all of us” - Ray Kroc
    “Actually, I *am* a rocket scientist.” - JB (little ones count!)

+ 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