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
Tools>Text to columns>follow 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