View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
wjohnson
 
Posts: n/a
Default Changing a word document into an excel spreadsheet


After you paste the info into EXCEL, Select ALL of Column A or whatever
Column you pasted the text into (do not select Cell A1 and DRAG down)
and select DATA - then Text To Columns you can manaully split (i.e.
Column A) into as many pieces as you want - just keep scrolling to the
right and placeing the "tabs" (ie division points) where ever you want.
Single click to "place a "cell break"" double click to remove it.
If this doesn't answer your question - then let me know.


--
wjohnson
------------------------------------------------------------------------
wjohnson's Profile: http://www.excelforum.com/member.php...o&userid=29640
View this thread: http://www.excelforum.com/showthread...hreadid=498035