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.-

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'.

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'.