View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Gary''s Student Gary''s Student is offline
external usenet poster
 
Posts: 11,058
Default 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 ?