http://www.labnol.org/forums/topic/word-to-excel Help Center Topic: Word to Excel en-US Mon, 13 Feb 2012 01:15:38 +0000 http://bbpress.org/?v=1.0.1 q http://www.labnol.org/forums/search.php http://www.labnol.org/forums/topic/word-to-excel#post-3172 Mon, 01 Sep 2008 08:15:41 +0000 Anonymous 3172@http://www.labnol.org/forums/ <p><a href="http://www.power-battery.com.au" rel="nofollow"><a href="http://www.power-battery.com.au" rel="nofollow">http://www.power-battery.com.au</a> </a> </p> http://www.labnol.org/forums/topic/word-to-excel#post-463 Fri, 31 Aug 2007 15:48:33 +0000 Anonymous 463@http://www.labnol.org/forums/ <p>Excellent Ram, this works perfectly. </p> http://www.labnol.org/forums/topic/word-to-excel#post-462 Fri, 31 Aug 2007 11:40:15 +0000 Anonymous 462@http://www.labnol.org/forums/ <p>OK. The picture is now clear. Since your data source is from WORD, you would not get the TRANSPOSE option. We can bypass it this way:</p> <p>1. Copy data from WORD<br /> 2. PASTE SPECIAL as TEXT in EXCEL<br /> 3. Now that you have your data in EXCEL, again copy this data. This time not from WORD but from EXCEL<br /> 4. Now try PASTE SPECIAL in a different row. You should be able to see the TRANSPOSE option :) </p> http://www.labnol.org/forums/topic/word-to-excel#post-441 Wed, 29 Aug 2007 15:31:57 +0000 Anonymous 441@http://www.labnol.org/forums/ <p>When I check Paste Special, I dont get a TRANSPOSE<br /> option. I get Picture, HTML, Unicode Text, Text and Hyperlink. I use Excel 2000. </p> http://www.labnol.org/forums/topic/word-to-excel#post-438 Wed, 29 Aug 2007 13:38:48 +0000 Anonymous 438@http://www.labnol.org/forums/ <p>nice one Ram!! </p> http://www.labnol.org/forums/topic/word-to-excel#post-436 Wed, 29 Aug 2007 11:22:09 +0000 Anurag 436@http://www.labnol.org/forums/ <p>Perfect Ram - Transpose is the way to go. </p> http://www.labnol.org/forums/topic/word-to-excel#post-435 Wed, 29 Aug 2007 11:03:32 +0000 Anonymous 435@http://www.labnol.org/forums/ <p>Even simpler.</p> <p>Copt data from WORD. Right click in EXCEL &gt; PASTE SPECIAL &gt; check the TRANSPOSE option. </p> http://www.labnol.org/forums/topic/word-to-excel#post-432 Wed, 29 Aug 2007 03:01:48 +0000 Anonymous 432@http://www.labnol.org/forums/ <p>Thanks, the way you explained it works quite<br /> well with columns. However I should have said I needed the data in ROWS instead of columns. The info is given to me like this:</p> <p>company<br /> address<br /> city<br /> state<br /> zip code</p> <p>but I need to put it into excel this way:<br /> Company Address City State Zipcode</p> <p>sorry for not clarifying this earlier.<br /> Monica </p> http://www.labnol.org/forums/topic/word-to-excel#post-430 Tue, 28 Aug 2007 22:25:20 +0000 Anonymous 430@http://www.labnol.org/forums/ <p>Just copy paste the table...</p> <p>It will work for sure</p> <p>cheers </p> http://www.labnol.org/forums/topic/word-to-excel#post-428 Tue, 28 Aug 2007 20:55:16 +0000 Anurag 428@http://www.labnol.org/forums/ <p>Copy the entire table in Word and paste that in Excel.</p> <p>Excel is smart enough to recognize tabular entries and auto-converts them into columns.</p> <p>If that doesn't work, attach some sample data here. </p> http://www.labnol.org/forums/topic/word-to-excel#post-421 Tue, 28 Aug 2007 11:46:30 +0000 Anonymous 421@http://www.labnol.org/forums/ <p>There is absolutely no need to get any SW. Simply copy the entire table from WORD and right click in EXCEL to PASTE SPECIAL. PASTE SPECIAL gives you many options to paste the content as. You can choose 'TEXT' if you simply need to retain the excel default format. Else you can choose from various other options like HTML etc. </p> http://www.labnol.org/forums/topic/word-to-excel#post-419 Tue, 28 Aug 2007 01:58:08 +0000 Anonymous 419@http://www.labnol.org/forums/ <p>Hi, if I have 300 entries with 8 columns (like what I have below) in Word, how can I convert it to excel without typing each entry. Is there a software I can download to do this?</p> <p>company<br /> address<br /> city<br /> state<br /> zip code<br /> contact person<br /> phone#<br /> email</p> <p>many thanks<br /> Monica </p>