Just some thoughts ..
Select the columnar range paste into Notepad
Then just select & copy the pasted range in Notepad,
back into Excel, click inside the formula bar of an empty cell paste
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"davfin" wrote:

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.


--
davfin
------------------------------------------------------------------------
davfin's Profile: http://www.excelforum.com/member.php...o&userid=36012
View this thread: http://www.excelforum.com/showthread...hreadid=557961