Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old December 17th 07, 01:07 PM posted to microsoft.public.excel.newusers
external usenet poster
 
First recorded activity by ExcelBanter: Dec 2007
Posts: 2
Default Splitting a cell

Can a column of cells be split into two equal parts with a line in the
middle? If so, how? I am using Excel 2000.

  #2   Report Post  
Old December 17th 07, 01:10 PM posted to microsoft.public.excel.newusers
external usenet poster
 
First recorded activity by ExcelBanter: Jan 2007
Posts: 161
Default Splitting a cell

"jayfin" wrote in message
...
Can a column of cells be split into two equal parts with a line in the
middle? If so, how? I am using Excel 2000.



Certainly later version have a "Text to Columns" function - not sure about
2000......SUCH a long time since I used it!!!!!


  #3   Report Post  
Old December 17th 07, 07:15 PM posted to microsoft.public.excel.newusers
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 22,908
Default Splitting a cell

A cell itself cannot be split into parts.

The contents of a cell can be split into multiple cells.


Gord Dibben MS Excel MVP

On Mon, 17 Dec 2007 04:07:01 -0800, jayfin
wrote:

Can a column of cells be split into two equal parts with a line in the
middle? If so, how? I am using Excel 2000.


  #4   Report Post  
Old December 18th 07, 02:02 AM posted to microsoft.public.excel.newusers
JMB JMB is offline
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 2,062
Default Splitting a cell

XL2000 has text to columns feature (Data/TextToColumns)


"Gordon" wrote:

"jayfin" wrote in message
...
Can a column of cells be split into two equal parts with a line in the
middle? If so, how? I am using Excel 2000.



Certainly later version have a "Text to Columns" function - not sure about
2000......SUCH a long time since I used it!!!!!



  #5   Report Post  
Old December 18th 07, 09:47 AM posted to microsoft.public.excel.newusers
external usenet poster
 
First recorded activity by ExcelBanter: Jan 2007
Posts: 161
Default Splitting a cell

"JMB" wrote in message
...
XL2000 has text to columns feature (Data/TextToColumns)


Thanks - I thought it might have but it's SO long since I used 2000 I wasn't
sure!




  #6   Report Post  
Old December 18th 07, 12:11 PM posted to microsoft.public.excel.newusers
external usenet poster
 
First recorded activity by ExcelBanter: Dec 2007
Posts: 2
Default Splitting a cell

It jayfin again. Thanks for the input. I decided that for my needs which
did not call for any manipulation of data, sorting etc., it would be easiest
to just take two columns and use the "merge and center" button over two
columns and label it with a centered title on one line of a cell and then on
the second line of the cell using the wrap text feature put a label above
each column. Had to do this with 25 columns but it did work.

"jayfin" wrote:

Can a column of cells be split into two equal parts with a line in the
middle? If so, how? I am using Excel 2000.

  #7   Report Post  
Old December 19th 07, 05:05 AM posted to microsoft.public.excel.newusers
JMB JMB is offline
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 2,062
Default Splitting a cell

We just upgraded to XL03 from XL00 at work <g.



"Gordon" wrote:

"JMB" wrote in message
...
XL2000 has text to columns feature (Data/TextToColumns)


Thanks - I thought it might have but it's SO long since I used 2000 I wasn't
sure!





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
Splitting a Cell williamr Excel Worksheet Functions 2 June 13th 07 01:30 AM
splitting a cell wnfisba Excel Discussion (Misc queries) 7 April 10th 07 10:22 AM
Splitting a cell David Excel Worksheet Functions 2 March 16th 06 08:36 PM
Splitting a cell c Excel Worksheet Functions 1 April 12th 05 02:40 PM
Splitting a Cell c Excel Worksheet Functions 5 April 11th 05 10:23 PM


All times are GMT +1. The time now is 02:40 PM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017