This question actually comes up frequently, and it can be hard to find the answer in Excel Help. The answer is no.
The reason is because each cell has to have a valid reference of a Column Letter and a Row Number. There is no such thing as column A-and-a-half.
Jared Hawk is a professional Excel Seminar Trainer and Consultant in Boise, Idaho. He is also a contributing author to www.masterthebusiness.com.
[…] one of the most searched posts on this is Can you divide an Excel cell in half? In it, I explain that you can’t. And you still can’t. But if you are trying to have a […]
Pingback by Excel Training Boise » Blog Archive » More on Dividing an Excel Cell in Half| Microsoft Excel Classes & Training Seminars in Boise, Idaho | Free Tips! — August 23, 2007 @ 1:37 am
There is more on this on another post, at http://exceltrainingboise.com/more-on-dividing-an-excel-cell-in-half/
Comment by Jared — August 23, 2007 @ 1:49 am