Dear all,

I want to separate a cell into two parts. I can do this by adding a diagonal
from "Fomat/Cell/Border". However, when I want to add text into two separate
parts, it cannot be done. The problem is the text description cannot be
separated into upper portion and lower portion as I expected. Can it be done
and how? Please advise.

Thanks.

You can have two lines of text in a cell by typing a few characters and then
Alt-Enter and then some more characters which will be on the second line.
If you preceed the second row characters it will move them to the lower
right corner of the cell and the first line characters will be in the upper
left area of the cell..........then a right-to-left diagonal border as
you've described will separate the cell and produce the visual effect you
are looking for.............

Vaya con Dios,
Chuck, CABGx3


"Freshman" wrote in message
...
Dear all,

I want to separate a cell into two parts. I can do this by adding a
diagonal
from "Fomat/Cell/Border". However, when I want to add text into two
separate
parts, it cannot be done. The problem is the text description cannot be
separated into upper portion and lower portion as I expected. Can it be
done
and how? Please advise.

Thanks.

Hi CLR,

I cannot get the effect by following your gudieline. Have I missed anything?
My steps a

Type: "Freshman" in a cell, then press Alt Enter;
Type: "CLR" in the second line, then press Enter.

The two lines of text still align on the left hand side and didn't separate
as you've described. Please kindly tell me if my steps have missed something.

Many thanks.

"Freshman" wrote:

Dear all,

I want to separate a cell into two parts. I can do this by adding a diagonal
from "Fomat/Cell/Border". However, when I want to add text into two separate
parts, it cannot be done. The problem is the text description cannot be
separated into upper portion and lower portion as I expected. Can it be done
and how? Please advise.

Thanks.

Assuming your diagonal format for the cell
is from top left to bottom right

instead of :
Type: "Freshman" in a cell, then press Alt Enter;

Type a few spaces (use the spacebar) before you type "Freshman", i.e. use
the spaces to push "Freshman" a little to the right, then press Alt Enter

and then just follow through with your
Type: "CLR" in the second line, then press Enter.

You'd need to manually adjust the spacing a little after viewing how it
looks with the diagonal drawn in

And if your diagonal is running the other way, do the spacing for the 2nd
text line in the cell instead of the 1st

Keep the alignment for the cell on the left
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--
"Freshman" wrote in message
...
Hi CLR,

I cannot get the effect by following your gudieline. Have I missed
anything?
My steps a

Type: "Freshman" in a cell, then press Alt Enter;
Type: "CLR" in the second line, then press Enter.

The two lines of text still align on the left hand side and didn't
separate
as you've described. Please kindly tell me if my steps have missed
something.

Many thanks.

Hi Max,

Thanks again. Your method works. Cheers.

"Max" wrote:

Assuming your diagonal format for the cell
is from top left to bottom right

instead of :
Type: "Freshman" in a cell, then press Alt Enter;

Type a few spaces (use the spacebar) before you type "Freshman", i.e. use
the spaces to push "Freshman" a little to the right, then press Alt Enter

and then just follow through with your
Type: "CLR" in the second line, then press Enter.

You'd need to manually adjust the spacing a little after viewing how it
looks with the diagonal drawn in

And if your diagonal is running the other way, do the spacing for the 2nd
text line in the cell instead of the 1st

Keep the alignment for the cell on the left
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--
"Freshman" wrote in message
...
Hi CLR,

I cannot get the effect by following your gudieline. Have I missed
anything?
My steps a

Type: "Freshman" in a cell, then press Alt Enter;
Type: "CLR" in the second line, then press Enter.

The two lines of text still align on the left hand side and didn't
separate
as you've described. Please kindly tell me if my steps have missed
something.

Many thanks.

You're welcome !
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--

The only thing you missed is how to read in MY sleep <g...........I swear
my response looked good to me last night just before I went to bed.......but
it sure didn't this morning. I see Max did come to my rescue and got you on
the straight and narrow tho.........thanks Max... ....just typing leading
spaces to either the top or bottom line, depending on which way the diagonal
goes, will move that line's characters over to the right end of the cell.

I do sincerely apologize for that first criptic response.

Vaya con Dios,
Chuck, CABGx3


"Freshman" wrote in message
...
Hi CLR,

I cannot get the effect by following your gudieline. Have I missed
anything?
My steps a

Type: "Freshman" in a cell, then press Alt Enter;
Type: "CLR" in the second line, then press Enter.

The two lines of text still align on the left hand side and didn't
separate
as you've described. Please kindly tell me if my steps have missed
something.

Many thanks.

"Freshman" wrote:

Dear all,

I want to separate a cell into two parts. I can do this by adding a
diagonal
from "Fomat/Cell/Border". However, when I want to add text into two
separate
parts, it cannot be done. The problem is the text description cannot be
separated into upper portion and lower portion as I expected. Can it be
done
and how? Please advise.

Thanks.

It's a pleasure to help out, Chuck ! <g
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--

Hi Chuck,

Thanks for your assistance too. I really appreciate your help. Thanks again.

Freshman

"CLR" wrote:

The only thing you missed is how to read in MY sleep <g...........I swear
my response looked good to me last night just before I went to bed.......but
it sure didn't this morning. I see Max did come to my rescue and got you on
the straight and narrow tho.........thanks Max... ....just typing leading
spaces to either the top or bottom line, depending on which way the diagonal
goes, will move that line's characters over to the right end of the cell.

I do sincerely apologize for that first criptic response.

Vaya con Dios,
Chuck, CABGx3


"Freshman" wrote in message
...
Hi CLR,

I cannot get the effect by following your gudieline. Have I missed
anything?
My steps a

Type: "Freshman" in a cell, then press Alt Enter;
Type: "CLR" in the second line, then press Enter.

The two lines of text still align on the left hand side and didn't
separate
as you've described. Please kindly tell me if my steps have missed
something.

Many thanks.

"Freshman" wrote:

Dear all,

I want to separate a cell into two parts. I can do this by adding a
diagonal
from "Fomat/Cell/Border". However, when I want to add text into two
separate
parts, it cannot be done. The problem is the text description cannot be
separated into upper portion and lower portion as I expected. Can it be
done
and how? Please advise.

Thanks.