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?