Select the column you want to divide, then - on the menu bar go to
"Data" then select "TEXT TO COLUMNS and follow the information on the
popup window. This will work, if the text you want to "throw away" is
at approximately the same location in each cell. If you "see empty
cells" - on the pop-up window use the slider bar to scroll down until
you come to a cell with text. Then put the mouse icon where you want to
divide the column and "click." Then continue to follow the directions
on the popup window. Then delete the column you don't want.


--
wjohnson
------------------------------------------------------------------------
wjohnson's Profile: http://www.hightechtalks.com/m390
View this thread: http://www.hightechtalks.com/t2307698