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 3. Total comments: 260

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

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

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

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

  5. Works Great! Thank you!

  6. 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.

  7. 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.

  8. 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.

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

  10. Superb.. Got valid info

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

  12. 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???

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

  14. Thanks this was helpful!

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

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

  17. THANK YOU LOT FOR GIVING LOT OF INFORMATION

  18. Very useful

  19. That trick using Notepad is neat :)

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

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

  22. 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

  23. 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.

  24. 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.

  25. 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.

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

  27. OK - that was useful - thanks man

  28. you guys rock

  29. 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!!

  30. very useful
    thanks.

  31. Thanks so much. Very helpful.

  32. Thanks for taking the time to give this detailed guide!

  33. Hi guys,

    would you please help me with merging cells where in one there is a place (city) and in second there is a time? Couldnt figure it our from the text above. Thank you very much.

  34. Using Office 365, the concatenate formula only worked after I changed the format of the column from "text" to "general".

  35. Thanks +++++

  36. Hi,
    I had two columns of names from 2017 and 2018, which I needed to combine. I copied then pasted the second column directly under the first column. I highlighted the entire column then "sorted" the column alphabetically.

    Hope this helped someone.

    1. Hi Evan,
      Thank you for sharing your solution.
      Please note that you can combine multiple sheets into one without copying and pasting your data using our Combine Worksheets Wizard. It can help you merge numerous sheets into one workbook, consolidate your data and even collect data from identically named sheets at a glance.

  37. Very helpful tutorial. It works like a champ and is very helpful. I am using Excel 2016 in Windows 10 and it worked on the first try.

  38. How to remove your addon from my computer?????????????

    1. Hello,
      Thank you for contacting us. I’m really sorry that you are having difficulty of this kind.
      Please try to uninstall the Ablebits product via Control Panel -> Programs and Features.
      Feel free to contact us if you need any further assistance.

  39. 100% worked. Thank you. I was able to add comment within formula.

    =CONCATENATE("Trans Date ",A46,", ",C46,", Cheque #", D46)

  40. Loved this tutorial! Worked 100%

  41. Hi,

    I have done merging of cells using the above formula with the ampersand sign hundreds of times - yet somehow - it does not seem to work with the current spreadsheet I have been provided. Is it due to the fact that it opens in compatibility mode? what can I change on the spreadsheet in order for this to work? Thanks

    1. Jaqueline:
      What is the formula you're using? Can you copy and paste it here?
      What is the result you're getting with the formula you're using?

  42. thanks.

  43. Information was helpful.

  44. Thanks, Exactly what I've been looking for. Saved me a lot of time.

  45. Simple Trick and Instructions But Can Save Ton's of Value Time....

  46. I just copy the name and address column and paste in Word table with the same number of rows and columns, then merge the cell.

  47. concatenation was superb function
    It saved my 8 hours effort :)

  48. Thank you for your post. It helps me alot. Thanks

  49. Thanks so much, this helped me a lot!

  50. Awesome!!

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 :)