Inserting from Clipboard - Troubles with "

T

Thomas Kehl

Hello.
I would like to insert data over the clipboard in Excel. This functioned so
far. Now however the problem that if in the data somewhere " occurs, is
Excel when inserting the following values on the same line inserts. Can't
that be gone around somehow - i.e. it can be adjusted somehow that Excel
when inserting " - indications to interpret is?

for example:

11111 " aaaaaa dddd
22222 " bbbbb cccc


I would like to insert this in Excel. The individual values are separate
tabulator. Now two lines should be inserted, whereby in each case the column
B " be contained are. The problem is now, the Excel now of " up to "
everything as a value regards and into a cell inserts. Thus finally a line
results. Can I go around somehow that Excel interprets everything between "
" as more lines text?

Excel version: Excel 2003 (11.8120.8122) SP2


Thank you for your assistance!

Regards, Thomas
 
Top