RE: techwr-l digest: October 20, 2005

[Derk Ederveen <derke -at- accountview -dot- com>]

	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.