how to split the unmerge cell in Excel? in Excel General Questions  
 |  Edit my Profile  |  Help
 
     
   
 
 
 
RR 7/28/2005 3:46 AM PST
  Question
  I have created more than 20 tables one by one downwards already. But now i
need one column in one table .suppose i try to insert column and change the
heading , at that time all table settings are changed. So that i need split a
cell that cell not merged.
 
  Was this post helpful to you?  
 
 
  Reply | Print post   TopTop  
 
 
 
 
FSt1 7/28/2005 3:57 AM PST
  Answer
  hi,
try this. on the xl toolbar....Data>Text to Colunms...

Be careful. Text to columns will delete any data to the right so add a
column or columns to accommidate the parsed data.

regards

FSt1

"RR" wrote:

> I have created more than 20 tables one by one downwards already. But now i
> need one column in one table .suppose i try to insert column and change the
> heading , at that time all table settings are changed. So that i need split a
> cell that cell not merged.
 
  Was this post helpful to you?  
 
 
  Reply | Print post   TopTop  
 
 
 
 
RR 7/28/2005 11:26 PM PST
   
  Hi,
I want split a cell only not data. pl. note that cell is not merged. any
tips pl.

"FSt1" wrote:

> hi,
> try this. on the xl toolbar....Data>Text to Colunms...
>
> Be careful. Text to columns will delete any data to the right so add a
> column or columns to accommidate the parsed data.
>
> regards
>
> FSt1
>
> "RR" wrote:
>
> > I have created more than 20 tables one by one downwards already. But now i
> > need one column in one table .suppose i try to insert column and change the
> > heading , at that time all table settings are changed. So that i need split a
> > cell that cell not merged.
 
  Was this post helpful to you?  
 
 
  Reply | Print post   TopTop  
 
 
 
 
Dave Peterson 7/29/2005 5:33 AM PST
   
  Excel won't let you split a cell (like you can do in MSWord).

You could insert another column and adjust your table, but you can't split a
cell.

RR wrote:
>
> Hi,
> I want split a cell only not data. pl. note that cell is not merged. any
> tips pl.
>
> "FSt1" wrote:
>
> > hi,
> > try this. on the xl toolbar....Data>Text to Colunms...
> >
> > Be careful. Text to columns will delete any data to the right so add a
> > column or columns to accommidate the parsed data.
> >
> > regards
> >
> > FSt1
> >
> > "RR" wrote:
> >
> > > I have created more than 20 tables one by one downwards already. But now i
> > > need one column in one table .suppose i try to insert column and change the
> > > heading , at that time all table settings are changed. So that i need split a
> > > cell that cell not merged.

--

Dave Peterson
 
  Was this post helpful to you?  
 
 
  Reply | Print post   TopTop  
 
 
  Return to Microsoft Communities  Notify me of replies