how to split the unmerge cell in Excel?

[RR]

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.

[FSt1]

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.

[RR]

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]

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