D
DCB
How does one subdivide a column on an excel spreadsheat?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
G
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
One could subdivide a column horizontally into groups of cells.
A1:A10, A11:A20 etc.
Gord Dibben MS Excel MVP
S
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
[email protected]
Replace @mailinator.com with @tiscali.co.uk
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
[email protected]
Replace @mailinator.com with @tiscali.co.uk
P
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
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