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.

Max Wrote:
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
---


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