General query on use of Excel

[DCB]

How does one subdivide a column on an excel spreadsheat?

 

[Gord Dibben]

One does not subdivide a column vertically.

One could subdivide a column horizontally into groups of cells.

A1:A10, A11:A20 etc.


Gord Dibben MS Excel MVP

 

[Sandy Mann]

It is not possible to subdivide a Column. You can merge some of the cells
between two columns so that it looks like the non-merged cells are a
subdivision of the combined Columns. However, sooner or later the merged
cells will cause you trouble.

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk

 

[Pete_UK]

You can't physically sub-divide a column, but you can split data out
into separate columns. For example, if you have codes in column A made
up of 3 letters followed by 4 numbers, then these formulae copied down
the columns will extract the letters into column B and the numbers
into column C:

B1: =LEFT(A1,3)
C1: =RIGHT(A1,4)*1

Hope this helps.

Pete