Split a Blank Cell into Two (Without Inserting Cell)

[mutax2003]

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.

[Gord Dibben]

Cannot be done.


Gord Dibben MS Excel MVP

On Mon, 24 Jul 2006 13:43:01 -0400, mutax2003
<[email protected]> 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.