I have a twist on this... I need to pull the complete text, with new lines from one workbook into another. It must be formatted exactly the same way in the destination cell. Setting one cell '=' to another strips out the new lines. Is this possible. Many thanks!