Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
allow text over a non-blank cell in Excel
How do I allow the text from A1 and text from B1 to display one over the
other at the same time |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
allow text over a non-blank cell in Excel
Hi!
Try this: =A1&CHAR(10)&B1 Format the cell to wrap text. Biff "Island" wrote in message ... How do I allow the text from A1 and text from B1 to display one over the other at the same time |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
allow text over a non-blank cell in Excel
You cannot allow this unless you take a picture of one of the cells and place
it over the other cell. SHIFT + EditCopy Picture This makes it hard to read either of the strings. What visual effect are you striving for that would prompt this question? Perhaps something can be worked out if we know that. Gord Dibben Excel MVP On Wed, 16 Nov 2005 13:49:49 -0800, Island wrote: How do I allow the text from A1 and text from B1 to display one over the other at the same time |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
allow text over a non-blank cell in Excel
I am copying comments from one sheet and pasting them into another sheet as
the value. If there are multiple comments I want to put a carriage return between the two so that they look like they are on a seperate line. I only have one row to use for these comments to be displayed or else I would just use the "Print at end of page" feature, not to mention there are things below where I need the comments to be displayed. "Gord Dibben" wrote: You cannot allow this unless you take a picture of one of the cells and place it over the other cell. SHIFT + EditCopy Picture This makes it hard to read either of the strings. What visual effect are you striving for that would prompt this question? Perhaps something can be worked out if we know that. Gord Dibben Excel MVP On Wed, 16 Nov 2005 13:49:49 -0800, Island wrote: How do I allow the text from A1 and text from B1 to display one over the other at the same time |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
allow text over a non-blank cell in Excel
Thanks for your help and sorry for not replying sooner.
I had seen it, but could not reproduce it at time of posting, but I finally succeed! The answer is actually quite curious. It seems to be a "bug" actually. In order to "see" the text one over the other, you put text in A1 (that is longer than colum width), you leave B1 blank, you write something in C1 and align right. If the text in C1 is long enough to reach A1, it will go over and you will see the content of A1 and C1 overlaped. Not quite scientific... But efficient for some visual effect Thank a lot for your time. "Stanley" wrote: I am copying comments from one sheet and pasting them into another sheet as the value. If there are multiple comments I want to put a carriage return between the two so that they look like they are on a seperate line. I only have one row to use for these comments to be displayed or else I would just use the "Print at end of page" feature, not to mention there are things below where I need the comments to be displayed. "Gord Dibben" wrote: You cannot allow this unless you take a picture of one of the cells and place it over the other cell. SHIFT + EditCopy Picture This makes it hard to read either of the strings. What visual effect are you striving for that would prompt this question? Perhaps something can be worked out if we know that. Gord Dibben Excel MVP On Wed, 16 Nov 2005 13:49:49 -0800, Island wrote: How do I allow the text from A1 and text from B1 to display one over the other at the same time |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
allow text over a non-blank cell in Excel
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Wrap text ceases to function in Excel if cell exceeds 9 lines | Excel Worksheet Functions | |||
Pasting Word table cell with paragraph markers into single Excel c | Excel Discussion (Misc queries) | |||
Wrap text limits in Excel 2003 cell formatting | Excel Discussion (Misc queries) | |||
?? Extra blank lines in 'address' cell after exporting to Excel | Excel Discussion (Misc queries) | |||
Why doesn't text wrap in a cell in Excel? | Excel Discussion (Misc queries) |