Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default Spliting a cell into two parts

How do I split a cell into two halves?

I would like to display a heading in cell C1.

I would llike to split cell C2 into two halves.

I want to display percentages in each half.

I am using Microsoft Excel 2003

Thank you for your help.
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3,942
Default Spliting a cell into two parts

hi
may we see a sample of the data in cell C2 that will be split???

Regards
FSt1

"Track68" wrote:

How do I split a cell into two halves?

I would like to display a heading in cell C1.

I would llike to split cell C2 into two halves.

I want to display percentages in each half.

I am using Microsoft Excel 2003

Thank you for your help.

  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 22,906
Default Spliting a cell into two parts

If you mean physically split a single cell into two halves.........cannot be
done.

If you want the contents of a single cell split into 2 cells, can be done.

A workaround for the first is to use the drawing toolbar to draw a line
splitting the cell into two parts.

Space out your data to fill both sides of the line.

Visual effect only.


Gord Dibben MS Excel MVP

On Wed, 2 Apr 2008 15:23:02 -0700, Track68
wrote:

How do I split a cell into two halves?

I would like to display a heading in cell C1.

I would llike to split cell C2 into two halves.

I want to display percentages in each half.

I am using Microsoft Excel 2003

Thank you for your help.


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Extract parts of a cell Aggies Excel Discussion (Misc queries) 6 May 22nd 07 01:01 AM
look for parts off contents in a cell FreddieP Excel Discussion (Misc queries) 2 September 6th 06 10:35 PM
How can I split one cell into two cell parts (upper & lower)? Desert Sparkle Excel Discussion (Misc queries) 0 January 5th 06 09:22 PM
hiding parts of a cell dick Excel Discussion (Misc queries) 3 October 17th 05 02:18 AM
Spliting the contents of a cell to other cells Lime Excel Worksheet Functions 6 October 14th 05 05:31 PM


All times are GMT +1. The time now is 06:27 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"