Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
add column into another column?
I`m aregentinian , so sorry for my limited english.
I would like to know how to add a column into another column , for example , divide into two columns the column "C" , beggining in file number "4".- Thank you all , big hug.- |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
add column into another column?
On Jul 5, 2:00*pm, Lobo Capo <Lobo
wrote: I`m aregentinian , so sorry for my limited english. I would like to know how to add a column into another column , for example , divide into two columns the column "C" , beggining in file number "4".- Thank you all , big hug.- I assume you mean beginning in Row 4... I'm afrad there isn't any way of doing this, as far as I know. What you can do, however, is to merge cells C1:D1, C2:D2, and C3:D3. If the rest of columns C and D remain unmerged, this may do what you want it to do. To merge cells, highlight e.g. C1:D1, and go to 'Format cells' (CTRL+F1 is a handy shortcut for this). On the 'Alignment' tab, select 'Merge cells'. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
add column into another column?
hi
an example of your data would have been nice but...... one way would be to use text to columns. Add a blank column to the left of C column then on the menu bar ToolsText to columnsfollow the wizard. use primarily to parce text files, it works goods for spliting columns provide the data is consitant. remember the blank column for text to columns will overwrite data. another way would be to use the left and right formula functions. you would need 2 blanks columns to this, one for each formula. since you didn't supply examples, i can only guess. data in C = abcdefgh formula in D: =left(C4,4) results=abcd formula e E: =right(C4,4) results= edgh read up on these formulas in xl help if your data is variing in length, might have trouble with the right functions. but there are way around that using the mid functions. post back if you have problems. Regards FSt1 " wrote: On Jul 5, 2:00 pm, Lobo Capo <Lobo wrote: I`m aregentinian , so sorry for my limited english. I would like to know how to add a column into another column , for example , divide into two columns the column "C" , beggining in file number "4".- Thank you all , big hug.- I assume you mean beginning in Row 4... I'm afrad there isn't any way of doing this, as far as I know. What you can do, however, is to merge cells C1:D1, C2:D2, and C3:D3. If the rest of columns C and D remain unmerged, this may do what you want it to do. To merge cells, highlight e.g. C1:D1, and go to 'Format cells' (CTRL+F1 is a handy shortcut for this). On the 'Alignment' tab, select 'Merge cells'. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
divide column(x) by column(y) to give column(x/y) in excel? | New Users to Excel | |||
Referencing date column A & time column B to get info from column | Excel Discussion (Misc queries) | |||
Return text in Column A if Column B and Column K match | Excel Worksheet Functions | |||
Based on a condition in one column, search for a year in another column, and display data from another column in the same row look | Excel Discussion (Misc queries) | |||
what formula do i put for column m = column k minus column l in e. | Excel Discussion (Misc queries) |