Re: Converting Word tables to Excel

[Ed Wurster <glassnet -at- gmail -dot- com>]

On 10/20/05, Becky Zoole <beckyzoole -at- gmail -dot- com> wrote:

> I I must copy data from several Word tables
> to Excel spreadsheets. The problem is that any hard return within a
> Word table cell is treated as an extra line in the Excel spreadsheet.
> Since my original has several instances like this, I have hours of
> clean-up to do.

> Is there any way to either remove the hard returns from the Word
> original before copying them, or to copy-paste the data into Excel in
> such a way that each Word table cell is treated as just one Excel
> cell, even if there ARE hard returns in it?

Select the table in Word, then look under the Table menu. Use the
convert table to text command. Copy the data, switch to Excel and
paste special (text only).


--
Ed Wurster (Voorhees, NJ)
Tech Tips Blog
http://www.ewurster.com/html/tech_tips.html

^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^

Try WebWorks ePublisher Pro for Word today! Smooth migration of legacy
RoboHelp content into your new Help systems. EContent Magazine Decision-
maker review (October 2005) is here: http://www.webworks.com/techwr-l

Doc-To-Help 2005 converts RoboHelp files with one click. Author with Word or any HTML editor. Visit our site to see a conversion demo movie and learn more. http://www.componentone.com/TECHWRL/DocToHelp2005

---
You are currently subscribed to techwr-l as:
archiver -at- techwr-l -dot- com
To unsubscribe send a blank email to leave-techwr-l-obscured -at- lists -dot- techwr-l -dot- com
Send administrative questions to lisa -at- techwr-l -dot- com -dot-  Visit
http://www.techwr-l.com/techwhirl/ for more resources and info.