Comments on: How to merge two columns in Excel without losing data

From this short article you will learn how to merge multiple Excel columns into one without losing data. Continue reading →

Comments page 2. Total comments: 260

  1. Thanks, indeed i needed this to complete my work

  2. OR:
    select your two columns to combine
    cut and paste without formatting into word doc
    add new empty column
    cut and paste copy from word doc into empty column
    DONE

  3. Life saver, thank you for much detailed and well informed guidance, greatly appreciated :-)

  4. VERY USEFUL...THANK YOU

  5. Very instructive tutorial! It helps me and I recommend it to other users!

  6. I really like your writing style, fantastic info, appreciate
    it for posting :D.

  7. Some genuinely interesting info, well written and loosely user genial.

  8. Your article was really a great help to me as I rarely use excel. Today using it for merging two columns without loosing value was an issue for me. Thanks for really a nice solution.

  9. I really like your writing style, great info, appreciate it for putting up :D.

  10. I used to be suggested this blog via my cousin. I am not positive whether
    this put up is written by means of him as nobody else recognise such
    targeted approximately my difficulty. You're amazing!
    Thank you!

  11. Very Helpful thanks

  12. This solution was a dream come true for me.
    I am making an English Persian legal dictionary. I had about 22,000 words and wanted to expand on it by translating new legal terminology but was wondering how to add the new terminology so the translated part could also be added with the new word.
    I never thought it was possible. Thank you.

  13. Thanks! Super Handy, I will be using this formula in my tool box now.

  14. SUPER!!!! GREAT! It really works! Thank you!!

  15. how to add date in this =CONCATENATE(M2, " , L2, ", J2)

  16. If you would like to take a great deal from this article then you
    have to apply such methods to your won blog.

  17. I used to be recommended this website by my cousin. I am now not sure whether or
    not this publish is written through him as nobody else know
    such particular about my problem. You are incredible!
    Thanks!

  18. Keep working ,impressive job!

  19. Thank you, I've just been looking for info about this subject for ages and yours is the greatest I have came upon till now.

    However, what in regards to the conclusion? Are you certain in regards to
    the source?

  20. Hi I am trying to merge 2 columns. First column contains dates-17/02/19 and second contains times 21:50. When I apply the formula above it just puts a long list of irrelevant numbers

  21. Wohh precisely what I was searching for, thank you for posting.

  22. Some truly interesting information, well written and broadly speaking user friendly.

  23. It?s hard to come by educated people on this subject,
    however, you seem like you know what you?re talking about!
    Thanks

  24. Thank you very much, your formula worked excellent.

  25. Works Great! Thank you!

  26. Great - I should certainly pronounce, impressed with your web site.
    I had no trouble navigating through all tabs and
    related info ended up being truly simple to do to access.
    I recently found what I hoped for before you know it at all.
    Quite unusual. Is likely to appreciate it for those who add forums
    or anything, website theme . a tones way for your customer to communicate.

    Excellent task.

  27. I cannot found the ablebits data menu on excel. In which version it can be found?

    1. Hi Shivani,

      The Ablebits Data tab appears after installing any of our tools. Currently, the Merge Cells add-in is included in our Ultimate Suite for Excel. Please check out the above linked page for full details.

  28. I knew about concatenate but i didn't had any idea about how to get the combined result with spaces and then to convert it into a value. Its really very informative. Thanks for sharing.

  29. If you want to obtain a great deal from this paragraph then you
    have to apply such strategies to your won website.

  30. Superb.. Got valid info

  31. Some genuinely interesting info, well written and broadly user genial.

  32. I did the add on and am following the directions but it is not adding a space, it is adding the wording [Space]. What am I doing incorrectly???

  33. How can convert multiple unequal columns in excel without gap to single column?

  34. Thanks this was helpful!

  35. This just gave additional ranking...Smiles, so happy. Thank you.

  36. This saved me so much time. Thank you!!!

  37. THANK YOU LOT FOR GIVING LOT OF INFORMATION

  38. Very useful

  39. That trick using Notepad is neat :)

  40. Thank you so much, it worked and saved me a helluva time

  41. very much informative, thank you very much, keep doing the great work

  42. I want to merge two column as One Bill No. and other as Bill date. Hear as per your above system for merging to single column, date format has changed in value, what is next procedure for making merge from two column in single column for my Bill No. and date

  43. Thanks very much it has so useful to me. i had a long list to be combined but with the use of this illustration i have succeeded indeed, however i did not go through to the last step.

  44. I want to merge 100 column, just like you merge three column
    =CONCATENATE(A1,",",B1,",",C1,",",D1,",",E1...........)

    writing above formula for 100 or 1000 column is time consuming.

  45. I have 1000 names in column A & 1000 in column B. I want to get in colum C in an alternative way. I.e. one data from column A in first row of colum B, then on second row the corresponding data from column B. It should be dynamic.

  46. What a time saver... Thank You, Thank You, Thank You!!!!!!

  47. OK - that was useful - thanks man

  48. you guys rock

  49. You can also just click an empty column next to the two you need combined and type. (Let's say A9=First Name and B9=Last Name and the new empty colomn is Fullname)
    =A9&" "&B9
    (The " " is to make a space between the two names.)
    Then hit enter. Select the combined cell and hover over the little box in the right lower corner so the cursor becomes a + and double click it. This will autofill the whole way down the list.
    Click the top of the column you just created for the Fullname to select the whole thing, ctrl+c (or copy), click in a cell right next to it and ctrl+v (or just paste the Value).
    Then you can delete the First Name and Last Name columns.
    Done. (It's kinda like a shorthand/freestyle version of the concatenate function.)

    1. Sam.. you are a GOD!!! Many goats will be sacrificed at your altar in the High Place! Thank you!!

  50. very useful
    thanks.

Post a comment



Thank you for your comment!
When posting a question, please be very clear and concise. This will help us provide a quick and relevant solution to
your query. We cannot guarantee that we will answer every question, but we'll do our best :)