Hi

I have a large spreadsheet that I need to trawl though consolidating column
cells. the process I haver been using is to select the cells and copy them
into word, convert them from table to text, copy the result, select the top
cell of the selection in excell and paste the result. This is a huge job
which could be speeded up hugely by a wee macro. I have used macros in MS
word and Access but the excel syntax is not familiar at all and I could
really do with some help.

In essence I need a macro that will take the contents of a selection (this
will be a number of cells containing text in a column) and join all of the
contents with a paragraph between. the resulting string is deposited in the
top cell and the remaining cells cleared of contents

I will have a go from examples I find but if someone has some code thay
could throw at me (or even some hints it would be well appreciated

Cheers
IanB