I
Island
How do I allow the text from A1 and text from B1 to display one over the
other at the same time
other at the same time
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
B
Biff
Hi!
Try this:
=A1&CHAR(10)&B1
Format the cell to wrap text.
Biff
Try this:
=A1&CHAR(10)&B1
Format the cell to wrap text.
Biff
G
Gord Dibben
You cannot allow this unless you take a picture of one of the cells and place
it over the other cell.
SHIFT + Edit>Copy 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
it over the other cell.
SHIFT + Edit>Copy 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
S
Stanley
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.
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.
S
Stephan Jodouin
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.
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.
G
Gord Dibben
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
Never noticed this before.
I would say it is a bug.
Gord
On Thu, 15 Dec 2005 08:10:03 -0800, Stephan Jodouin <Stephan