ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   2 Values in 1 Cell (https://www.excelbanter.com/excel-discussion-misc-queries/124335-2-values-1-cell.html)

Keith J.

2 Values in 1 Cell
 
I am looking to create a table w/o forumlas that will allow me to put two
separate values in the same "cell". In other words my idea is for it to look
like this:

___________
| #1 / |
| / |
| / |
|__/__#2___|

I don't care if it is one cell or two merged ones or however it can be done.
I cannot seem to ask online help or this newsgroup search the right
question. The only answer I can seem to find is one that says you cannot
have two values in one cell. Any way around that? THANKS!!

pinmaster

2 Values in 1 Cell
 
Hi

Try this: type your first number then hit the ALT+ENTER keys, that will add
a carriage return to the cell next add some blank characters (space bar)
followed by your second number or vise versa depending on which corner you
want your numbers next format your cell with a diagonal line.

Hope this helps!
Jean-Guy

"Keith J." wrote:

I am looking to create a table w/o forumlas that will allow me to put two
separate values in the same "cell". In other words my idea is for it to look
like this:

___________
| #1 / |
| / |
| / |
|__/__#2___|

I don't care if it is one cell or two merged ones or however it can be done.
I cannot seem to ask online help or this newsgroup search the right
question. The only answer I can seem to find is one that says you cannot
have two values in one cell. Any way around that? THANKS!!


Bill Kuunders

2 Values in 1 Cell
 
You would need to pre- format the cells to be text in stead of general

If you do want the different levels in the cell, use <alt<enter after
entering the /

Greetings from New Zealand

"Keith J." wrote in message
...
I am looking to create a table w/o forumlas that will allow me to put two
separate values in the same "cell". In other words my idea is for it to
look
like this:

___________
| #1 / |
| / |
| / |
|__/__#2___|

I don't care if it is one cell or two merged ones or however it can be
done.
I cannot seem to ask online help or this newsgroup search the right
question. The only answer I can seem to find is one that says you cannot
have two values in one cell. Any way around that? THANKS!!




Keith J.

2 Values in 1 Cell
 
The noise you heard was me "oooohhhhhhh" "SMACK" (hand hitting forehead).
Funny thing is I knew the "alt" but never went the next step!!!! THANKS!!!!

"pinmaster" wrote:

Hi

Try this: type your first number then hit the ALT+ENTER keys, that will add
a carriage return to the cell next add some blank characters (space bar)
followed by your second number or vise versa depending on which corner you
want your numbers next format your cell with a diagonal line.

Hope this helps!
Jean-Guy

"Keith J." wrote:

I am looking to create a table w/o forumlas that will allow me to put two
separate values in the same "cell". In other words my idea is for it to look
like this:

___________
| #1 / |
| / |
| / |
|__/__#2___|

I don't care if it is one cell or two merged ones or however it can be done.
I cannot seem to ask online help or this newsgroup search the right
question. The only answer I can seem to find is one that says you cannot
have two values in one cell. Any way around that? THANKS!!


pinmaster

2 Values in 1 Cell
 
Wondered what that noise was :)

Glad I could help!

Cheers!
Jean-Guy

"Keith J." wrote:

The noise you heard was me "oooohhhhhhh" "SMACK" (hand hitting forehead).
Funny thing is I knew the "alt" but never went the next step!!!! THANKS!!!!

"pinmaster" wrote:

Hi

Try this: type your first number then hit the ALT+ENTER keys, that will add
a carriage return to the cell next add some blank characters (space bar)
followed by your second number or vise versa depending on which corner you
want your numbers next format your cell with a diagonal line.

Hope this helps!
Jean-Guy

"Keith J." wrote:

I am looking to create a table w/o forumlas that will allow me to put two
separate values in the same "cell". In other words my idea is for it to look
like this:

___________
| #1 / |
| / |
| / |
|__/__#2___|

I don't care if it is one cell or two merged ones or however it can be done.
I cannot seem to ask online help or this newsgroup search the right
question. The only answer I can seem to find is one that says you cannot
have two values in one cell. Any way around that? THANKS!!



All times are GMT +1. The time now is 08:22 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com