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

Question

E.g

A1:I
A2:am
A3:a
A4:boy 

I want to merge them all to a single cell "Iamaboy"
This example shows 4 cells merge into 1 cell however I have many cells (more than 100), I can't type them one by one using A1 & A2 & A3 & A4 what can I do?

Answer 1

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.