View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.misc
Max Max is offline
external usenet poster
 
Posts: 9,221
Default How do I copy the contents of a range of text cells and paste

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.