Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
General query on use of Excel
How does one subdivide a column on an excel spreadsheat?
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Format: General - Text - General | Excel Worksheet Functions | |||
Anyone Else Use Database Query to Query Another Sheet in the Same Excel Workbook? | Excel Discussion (Misc queries) | |||
Anyone Else Use Database Query to Query Another Sheet in the Same Excel Workbook? | Excel Discussion (Misc queries) | |||
excel general questions | Excel Discussion (Misc queries) | |||
How to use a Access Query that as a parameter into Excel database query | Excel Discussion (Misc queries) |