Good afternoon Mark
Is this what you are looking for?
Par
------------
On hand
Without the white space between the words?
If it is you can do this in an Excel cell by:
Typing in the word Par plus 3 or 4 spaces - then use ALT + ENTER
Then type in On hand and hit Enter
Go back to the cell and in the formula bar select Par and go to Format - Cells - Font and select Underline.
You can add or remove spaces after Par to get the line length that you want.
Let me know if this works for you.
Thanks,
Jon Barchenger
--------------------
**From: mrkhalife <<
[email protected]>>
**Subject: Split words in one cell
**Date: Tue, 3 Feb 2004 08:52:58 -0600
**Message-ID: <
[email protected]>
**Organization: ExcelTip
**User-Agent: ExcelTipForum
**X-Newsreader: ExcelTipForum
**X-Originating-IP: 212.138.47.14
**Newsgroups: microsoft.public.excel.worksheet.functions
**NNTP-Posting-Host: 69-56-172-122.theplanet.com 69.56.172.122
**Lines: 1
**Path: cpmsftngxa07.phx.gbl!cpmsftngxa10.phx.gbl!TK2MSFTNGXA05.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP09.phx.gbl
**Xref: cpmsftngxa07.phx.gbl microsoft.public.excel.worksheet.functions:187132
**X-Tomcat-NG: microsoft.public.excel.worksheet.functions
**
**Please help. I am trying to put two words in one cel and have them spli
by a line.
**
**For example Par/On hand
**
**I know that I can right click on a cel and then go to format cel an
chose borders and make a line that goes at an angle. But I want on
word to be on top of the line and the other word to be on the bottom o
the line. How can I do that?
**
**thanks,
**Mar
--
**
