Suppose the data is in A1:A100
Move to A51, select A51:A100 with mouse, use copy; move to b1 and use Paste

Or do you have data like this
John Smith
and you want John in one cell, Smith in another?
If so experiment with he Data|Text to columns feature

best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Jeanne" wrote in message
...
IncExcel, how do I create multiple columns within one column? I have a
block
of rows within one column and I need to create at least two columns. Is
it
possible?