View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Allllen[_2_] Allllen[_2_] is offline
external usenet poster
 
Posts: 13
Default Convert Single ALPHA Column to Two


Insert a new blank column on the right of your current column.
Go about halfway down your list and select a cell.
Do control+shift and down, to select all the cells from the middle to the
bottom of your column.
Right click
Cut
Go to the top of the new column you created
select the first cell
right click
paste

--
Allllen


"Lin400" wrote:

I have almost 800 rows of alpha titles in one column I want to split into two
columns, while keeping them in alphabetical order - side-by-side rather than
one long alpha list.

Is this poss without spending hours moving each line manually?

V. Excel 2003