How do I one larger column into 3 subcolumns?

[DebbieAnneSchmidt]

I am doing a spreadsheet where in one column (column A) has a heading and I
need to split it into 3 thinner columns with their own names. How do I do
this?

 

[YH]

I am doing a spreadsheet where in one column (column A) has a heading and I
need to split it into 3 thinner columns with their own names. How do I do
this?

I don't believe you can split columns in excel however, you merge column A
across columns A, B, C.

 

[Duke Carey]

Merge Cells=Work of the Devil

There is almost ALWAYS a better approach than merging cells.

Debbie Ann - just what are you trying to accomplish? Is there three
separate items of data in column A that you want to split out, or is it
something else?

 

[Spiky]

I don't believe you can split columns in excel however, you merge column A
across columns A, B, C.

There are 2 ways, not counting macros. One is to use Text To Columns
from the Data menu. The other is to use various functions from the
Text group of functions. RIGHT, LEFT, LEN, etc. depending on exactly
what your data looks like.

 

[Gord Dibben]

If you have three items in one cell you can use Data>Text to Columns to
split the items into 3 columns.

Using some de-limiter like <space> or fixed width.

Just be careful that you don't have anything in Columns B and C before you
split.


Gord Dibben MS Excel MVP