Hi,
Excel 2003 question:

I have a sheet that contains text in consecutive cells (in a column), I need to copy all the consecutive cells' texts into one cell in a separate spreadsheet.
Is there any quick way to do this? Just selecting the individual texts and copy/pasting is time consuming and a pain. I have multiple occurrences of this and need to find a quick way.

All help and suggestions very much appreciated.
Thanks,
Dave.