Re: Converting Word tables to Excel

Subject: Re: Converting Word tables to Excel
From: Ed Wurster <glassnet -at- gmail -dot- com>
To: "TECHWR-L" <techwr-l -at- lists -dot- techwr-l -dot- com>
Date: Fri, 21 Oct 2005 06:43:21 -0400

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


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:

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.

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 for more resources and info.

Converting Word tables to Excel: From: Becky Zoole

Previous by Author: Re: Asking The Billing Rate?
Next by Author: Re: "^p" equivalent in Notepad?
Previous by Thread: Converting Word tables to Excel
Next by Thread: Excel to word table - additional part of question!

What this post helpful? Share it with friends and colleagues:

Sponsored Ads