View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default 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.