Thread
:
Lock Linked Cells And Unlinked Cells In A Row
View Single Post
07-14-2014, 07:50 AM
paulkaye
Windows 7 64bit
Office 2007
Advanced Beginner
Join Date: Nov 2011
Posts: 84
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
paulkaye
View Public Profile
Find all posts by paulkaye