How to merge rows in a column into one cell in excel?

by

If you prefer to do this without VBA, you can try the following:

  1. Have your data in cells A1:A999 (or such)
  2. Set cell B1 to “=A1”
  3. Set cell B2 to “=B1&A2”
  4. Copy cell B2 all the way down to B999 (e.g. by copying B2, selecting cells B3:B99 and pasting)

Cell B999 will now contain the concatenated text string you are looking for.

More Related Contents:

  1. Excel Number Separation [closed]
  2. excel vba compare & copy worksheets from 2 excel files
  3. VBA Stuck after certain loop
  4. How do I use FileSystemObject in VBA?
  5. Is the . in .Range necessary when defined by .Cells?
  6. How to return a result from a VBA function
  7. Cycle through sub-folders and files in a user-specified root directory [duplicate]
  8. Convert Text to Date?
  9. Loop through each cell in a range of cells when given a Range object
  10. Non-web SQL Injection
  11. How to copy sheets to another workbook using vba?
  12. Autofilter with column formatted as date
  13. Excel vba refresh wait
  14. Excel vba to create every possible combination of a Range
  15. Excel VBA: getting row of clicked button [duplicate]
  16. VBA Many buttons point to the same _Click sub
  17. Excel VBA Filter Change event handler
  18. How to copy only values in excel vba from a range?
  19. How to suppress Update Links warning?
  20. How do we use restful APIs from Excel macros (vba)?
  21. Run a Macro from Another Workbook
  22. Cannot VBA write data to cells in Excel 2007/2010 within a function
  23. Sorting a dictionary by key in VBA
  24. Handle “No cells were found” error when filtered range is empty
  25. Excel: the Incredible Shrinking and Expanding Controls [closed]
  26. How to send email to multiple recipients with addresses stored in Excel?
  27. Generate Word Documents (in Excel VBA) from a series of Document Templates
  28. Using Excel VBA Macro To Capture + Save Screenshot of Specific Area In Same File
  29. How to protect Excel workbook using VBA?
  30. How to get the range of the visible rows after applying an advanced filter in Excel (VBA)

Leave a Comment