How do I copy the contents of a range of text cells and paste into one cell?

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
>
>

whoops, typo in line:
> Select the columnar range > paste into Notepad

should read as:
> Select the columnar range > copy & paste into Notepad
(missed out the "copy" part)
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

Max,
Thanks for the suggestion - as always the simple things are often the best, it works a treat after you delete the space between the texts while it's in Notepad (it contains the Excel formatting and will paste into separate cells otherwise). It's then a simple case of inserting spaces where needed once it's pasted into the new spreadsheet cell.

Thanks,
Dave.

Originally Posted by Max

whoops, typo in line:
> Select the columnar range > paste into Notepad

should read as:
> Select the columnar range > copy & paste into Notepad
(missed out the "copy" part)
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

Glad it worked, Dave.
Thanks for the feedback ..
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"davfin" wrote:
>
> Max,
> Thanks for the suggestion - as always the simple things are often the
> best, it works a treat after you delete the space between the texts
> while it's in Notepad (it contains the Excel formatting and will paste
> into separate cells otherwise). It's then a simple case of inserting
> spaces where needed once it's pasted into the new spreadsheet cell.
>
> Thanks,
> Dave.