View Single Post
 
Old 12-06-2005, 01:51 AM
heron heron is offline
Novice
 
Join Date: Dec 2005
Posts: 2
heron
Default paste formated text from Word to only one Excel cell

Hi everyone,
I have to paste repetitively small text pieces from Word in Excel cells. The source text in Word is not "clean": it contains some tabs and line feeds.
[Please note that it is not possible to simply erase all tabs in the word document (we need them to know what to copy)]

The probleme is that when I past it into Excel, it is split on several cells.

What I would like to do is to copy only "raw text" without the tabs and new line feed so that everything get paste in only ONE cell in Excel.

Thanks in advance for your help.

Heron
Reply With Quote