RE: techwr-l digest: October 20, 2005

Subject: RE: techwr-l digest: October 20, 2005
From: Derk Ederveen <derke -at- accountview -dot- com>
To: "TECHWR-L" <techwr-l -at- lists -dot- techwr-l -dot- com>
Date: Fri, 21 Oct 2005 10:13:47 +0200

Becky wrote:

> 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.
> 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?
[de] I found that the following works:

- select the table in Word: Table/Select/Table
- use Edit/Replace to replace all hard returns (^p) in the table
with a character you don't use (e.g. | )
- use Table/Convert/Table to text (use tabs)
- select Edit/Copy
- switch to Excel
- select Edit/Paste
- select Edit/Replace, type your separation character ( | ) in 'Find
what', and type ALT+'010' (the hard return character) in 'Replace with'

Hope this helps,



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.

Previous by Author: RE: A PDA in every pocket?
Next by Author: Re: Blank output in in Word/PDF
Previous by Thread: Re: Rusty in RH HTML 200
Next by Thread: RE: techwr-l digest: October 20, 2005

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

Sponsored Ads