Splitting Cells

K

Karl

Hi I would like to know how can you split a cell into like 4 parts without doing the whole column. For instance have one cell state Monday but the cell below it say |C|S|H|P| broken up like this into 4 cells. All help would be appreciated. Thanks Karl Lungmus
 
G

Gord Dibben

Karl

Width of a column is uniform from top to bottom.

I would suggest you use "Center across selection" for the top cell then have
the |C|S|H|P| in four columns below.

e.g. Enter Monday in A1. Select A1 through D1 and
Format>Cells>Alignment>Horizontal "center across selection".

In A2 through D2 enter C S H P

Gord Dibben Excel MVP
 
M

MARK

-----Original Message-----
Hi I would like to know how can you split a cell into
Click to expand...
like 4 parts without doing the whole column. For instance
have one cell state Monday but the cell below it say
|C|S|H|P| broken up like this into 4 cells. All help would
be appreciated. Thanks Karl Lungmus
.
Click to expand...
Use the "text to columns" feature to parse (split) the
cell. Just have your cursor in the only cell(s) you want
to split. You do not need to select the whole column.

Good Luck.
 
Top