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

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.