Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Diving 1 cell question
HELP! I am trying to divide a single cell to where I can type a fraction
like result. I need the horizontal border in the cell to divide the cell but I need to type one word on top of the border and one word on the bottom. Here is somewhat of an example: Fd/Fm (this should be in one cell with the "Fd" on the top left of the cell and the "Fm" on the bottom right while the cell still appears as split with the horizontal line in the middle "dividing" the cell). Does anyone know what I am talking about? Can anyone help ? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Diving 1 cell question
="fd" & CHAR(10) & "------" & CHAR(10) & "fm" and format the cell with wrap on.
adjust either the column width or the number of minus signs to give a visually acceptable result. -- Gary''s Student - gsnu200803 "Jennifer" wrote: HELP! I am trying to divide a single cell to where I can type a fraction like result. I need the horizontal border in the cell to divide the cell but I need to type one word on top of the border and one word on the bottom. Here is somewhat of an example: Fd/Fm (this should be in one cell with the "Fd" on the top left of the cell and the "Fm" on the bottom right while the cell still appears as split with the horizontal line in the middle "dividing" the cell). Does anyone know what I am talking about? Can anyone help ? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Diving 1 cell question
Thank you for your reply however this answer is a bit over my head. Can you
explain in more general terms? Also, I just used "fd" and "fm" as an example, I need to enter various words/letters and not just those. Thank you again for your answer. Please further clarify if possible. "Gary''s Student" wrote: ="fd" & CHAR(10) & "------" & CHAR(10) & "fm" and format the cell with wrap on. adjust either the column width or the number of minus signs to give a visually acceptable result. -- Gary''s Student - gsnu200803 "Jennifer" wrote: HELP! I am trying to divide a single cell to where I can type a fraction like result. I need the horizontal border in the cell to divide the cell but I need to type one word on top of the border and one word on the bottom. Here is somewhat of an example: Fd/Fm (this should be in one cell with the "Fd" on the top left of the cell and the "Fm" on the bottom right while the cell still appears as split with the horizontal line in the middle "dividing" the cell). Does anyone know what I am talking about? Can anyone help ? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Diving 1 cell question
If you copy the formula from my first response and paste it in a cell, it
should display your desired result. You can replace "fd" and "fm" with any other text. You can also replace them with cell references. -- Gary''s Student - gsnu200803 "Jennifer" wrote: Thank you for your reply however this answer is a bit over my head. Can you explain in more general terms? Also, I just used "fd" and "fm" as an example, I need to enter various words/letters and not just those. Thank you again for your answer. Please further clarify if possible. "Gary''s Student" wrote: ="fd" & CHAR(10) & "------" & CHAR(10) & "fm" and format the cell with wrap on. adjust either the column width or the number of minus signs to give a visually acceptable result. -- Gary''s Student - gsnu200803 "Jennifer" wrote: HELP! I am trying to divide a single cell to where I can type a fraction like result. I need the horizontal border in the cell to divide the cell but I need to type one word on top of the border and one word on the bottom. Here is somewhat of an example: Fd/Fm (this should be in one cell with the "Fd" on the top left of the cell and the "Fm" on the bottom right while the cell still appears as split with the horizontal line in the middle "dividing" the cell). Does anyone know what I am talking about? Can anyone help ? |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Diving 1 cell question
Revising the formula a bit...........
=A1&CHAR(10)&REPT("_",LEN(A1))&CHAR(10)&B1 Enter the formula in C1 and the text in A1 and B1 Gord Dibben MS Excel MVP On Mon, 8 Sep 2008 06:27:01 -0700, Jennifer wrote: Thank you for your reply however this answer is a bit over my head. Can you explain in more general terms? Also, I just used "fd" and "fm" as an example, I need to enter various words/letters and not just those. Thank you again for your answer. Please further clarify if possible. "Gary''s Student" wrote: ="fd" & CHAR(10) & "------" & CHAR(10) & "fm" and format the cell with wrap on. adjust either the column width or the number of minus signs to give a visually acceptable result. -- Gary''s Student - gsnu200803 "Jennifer" wrote: HELP! I am trying to divide a single cell to where I can type a fraction like result. I need the horizontal border in the cell to divide the cell but I need to type one word on top of the border and one word on the bottom. Here is somewhat of an example: Fd/Fm (this should be in one cell with the "Fd" on the top left of the cell and the "Fm" on the bottom right while the cell still appears as split with the horizontal line in the middle "dividing" the cell). Does anyone know what I am talking about? Can anyone help ? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Cell Ref question | Excel Discussion (Misc queries) | |||
Cell Formatting Question | Excel Worksheet Functions | |||
Conditional Formatting question (if cell = 0, wrap cell in quotes) | New Users to Excel | |||
Cell question | Excel Worksheet Functions | |||
cell reference question | Excel Discussion (Misc queries) |