|
|
|
|
#1
07-14-2014, 07:50 AM
|
|||
|
|||
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 
|
|
#2
07-14-2014, 10:15 AM
|
||||
|
||||
|
Without seeing it for myself I can't be sure, but this sounds like a good solution, paulkaye. Does that take care of everything or are there more questions?
|
|
| Tags |
| alignment, linking, worksheet |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Update Link very slow -PowerPoint Charts & object, cells etc Linked to Excel | johnseito | PowerPoint | 0 | 01-28-2014 06:24 PM |
 How to lock only some cells in 2010 ?
|
spookiepower | Word | 4 | 11-26-2013 02:40 PM |
| linked cells | msheyworth | Excel | 5 | 04-03-2012 03:12 PM |
| placing linked Excel cells in Word next to a chart | Paul-NYS | Word | 4 | 03-16-2012 12:59 PM |
| Protect / Lock Cells / Print Set-up? | meggenm | Excel | 3 | 01-26-2012 09:57 PM |
Windows 7 64bit 
Office 2007
Hybrid Mode