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

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

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

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

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

allow text over a non-blank cell in Excel
 

Stephan

Never noticed this before.

I would say it is a bug.


Gord

On Thu, 15 Dec 2005 08:10:03 -0800, Stephan Jodouin <Stephan
wrote:

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