ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Split a Blank Cell into Two (Without Inserting Cell) (https://www.excelbanter.com/excel-discussion-misc-queries/100939-split-blank-cell-into-two-without-inserting-cell.html)

mutax2003

Split a Blank Cell into Two (Without Inserting Cell)
 

I want to split a blank cell into two, and the new cells will be half
the size of the original cell, but without using inserting cell
command, is there anyway to do it? I've tried "text to column"
command, but it is not the command I am looking for. If you know any
command or have a macro that does this, please let me know by replying
to my email address. Thanks.


--
mutax2003
------------------------------------------------------------------------
mutax2003's Profile: http://www.excelforum.com/member.php...o&userid=36706
View this thread: http://www.excelforum.com/showthread...hreadid=564395


Gord Dibben

Split a Blank Cell into Two (Without Inserting Cell)
 
Cannot be done.


Gord Dibben MS Excel MVP

On Mon, 24 Jul 2006 13:43:01 -0400, mutax2003
wrote:


I want to split a blank cell into two, and the new cells will be half
the size of the original cell, but without using inserting cell
command, is there anyway to do it? I've tried "text to column"
command, but it is not the command I am looking for. If you know any
command or have a macro that does this, please let me know by replying
to my email address. Thanks.




All times are GMT +1. The time now is 02:24 AM.

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