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,

-de


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

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.



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