View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
ShaneDevenshire ShaneDevenshire is offline
external usenet poster
 
Posts: 2,344
Default converting text from word to excel.

Hi,

The secret it in Word. Select the data in Word, and choose the command
Table, Convert, Text to Table.

Now copy the table from Word to Excel.


If this helps, please click the Yes button.
--
Thanks,
Shane Devenshire


"darkfeld" wrote:

How can I take text that I have typed in Word 2003 and transfer it into one
cell in Microsoft Excel 2007? The text in Word has tabs in between it and I
cannot get it to transfer into only one cell. It keeps breaking the text up
into different cells where the tab is located. Any ideas?