Question

write steps to spilt the centre cell

Answer 1

Select the cell or cells whose contents you want to split. ...On the Data tab, in the Data Tools group, click Text to Columns. ...Choose Delimited if it is not already selected, and then click Next.

Answer 2

To spilt cells ,do as follows:-

1) Click the cells.

2) Click the layout tab.

3) In the merge group, click the spilt cells option . The spilt cells dialog box appears.

4)Specify the number of rows and columns. Then click OK.