General query on use of Excel
 

How does one subdivide a column on an excel spreadsheat?

General query on use of Excel
 

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

On Fri, 28 Mar 2008 10:40:01 -0700, DCB wrote:

How does one subdivide a column on an excel spreadsheat?

General query on use of Excel
 

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


Replace @mailinator.com with @tiscali.co.uk


"DCB" wrote in message
...
How does one subdivide a column on an excel spreadsheat?

General query on use of Excel
 

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

On Mar 28, 5:40*pm, DCB wrote:
How does one subdivide a column on an excel spreadsheat?