Thread: Splitting Cells
View Single Post
  #2   Report Post  
Gary's Student
 
Posts: n/a
Default

First format the cell as Text. Then enter the two values separated by any
character you desire. The cell will hold exactly what you typed.
--
Gary's Student


"MFFC2005" wrote:


Im trying to enter two values into the same cell. I've seen it done, it
has a red diagonal line seperating the two values.

Thanks for any help.


--
MFFC2005
------------------------------------------------------------------------
MFFC2005's Profile: http://www.excelforum.com/member.php...o&userid=25816
View this thread: http://www.excelforum.com/showthread...hreadid=392130