ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   New Users to Excel (https://www.excelbanter.com/new-users-excel/)
-   -   Splitting Cells (https://www.excelbanter.com/new-users-excel/38285-splitting-cells.html)

MFFC2005

Splitting Cells
 

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


Gary's Student

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




All times are GMT +1. The time now is 10:07 AM.

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