Excel - how does one subdivide a column on an excel spreadsheet

Asked By DC on 29-Mar-08 08:02 PM




Gord Dibben replied on 29-Mar-08 08:20 PM
In the same manner one could not yesterday when you posted the same question.

Columns are single entities and cannot be "split" into sections vertically.


Gord Dibben  MS Excel MVP
Hollie replied on 08-Apr-08 01:39 PM
Select the SINGLE column and go to Data -> Text to columns.

You don't have to do all of the column (I usually just do a few hundred
lines) but it only works with a single column.