Merge/Combine data in a column of many rows into one cell separated by a space

[StreekyD]

I have one column of data in 67 rows. How do I merge all the data into one cell?
aaa aaa bbb ccc ddd
bbb
ccc
ddd

[daffodil11]

Assuming your data runs A1:A67, then in B1 put =A1, in B2 put =B1&" "&A2, and then copy the formula in B2 downwards

concatenation magic.xlsx

[StreekyD]

Many Thanks
I copied the last row after applying and pasted all in a cell.
I knew it had to be simple!!

[daffodil11]

Woo woo! Another satisfied customer!



Glad I could be of assistance.

[Debraj Roy]

One lil bit larger method.. :)

Insert Formula..
=A1:A67

select red area in formula bar.. and press F9.
Now delete.. (=) and double Find & Replace..
1. (") Quote to () Nothing
2. (;) Semicolon to ( ) Space