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.

hi,
try this. on the xl toolbar....DataText 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.

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....DataText 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.

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....DataText 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