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?

"DebbieAnneSchmidt" wrote:

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.

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?


"YH" wrote:



"DebbieAnneSchmidt" wrote:

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.

On Aug 1, 1:35 pm, YH wrote:
"DebbieAnneSchmidt" wrote:
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.

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.

If you have three items in one cell you can use DataText 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

On Fri, 1 Aug 2008 11:20:01 -0700, DebbieAnneSchmidt
wrote:

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?