View Single Post
 
Old 07-14-2014, 07:50 AM
paulkaye paulkaye is offline Windows 7 64bit Office 2007
Advanced Beginner
 
Join Date: Nov 2011
Posts: 84
paulkaye is on a distinguished road
Default

Solved it!

I place a semicolon within data3 each time there should be a new line. I enter data3 in this way on one line in sheet1, and use the SUBSTITUTE function in combination with CHAR(10) to display data3 on multiple lines in sheet2.

Paul
Reply With Quote