wayne emery
New Member
- Joined
- Sep 20, 2006
- Messages
- 3
Is it possible to put two lots of text in one cell?
I have two worksheets with identical numbers of rows & collumns. Some of these cells contain values and some contain text.
If I create a third worksheet I can easilly add the numerical valuess of cell A1 for worksheet 1 to the contents of cell A1 in worksheet 2 and show the result in worksheet 3. However where for example cell A2 always contains text in both worksheets how can I show both sets of text in worksheet 3 cell A2.
I have two worksheets with identical numbers of rows & collumns. Some of these cells contain values and some contain text.
If I create a third worksheet I can easilly add the numerical valuess of cell A1 for worksheet 1 to the contents of cell A1 in worksheet 2 and show the result in worksheet 3. However where for example cell A2 always contains text in both worksheets how can I show both sets of text in worksheet 3 cell A2.