Re: how do I paste or import without parsing??

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

The parsing occurs when I open up a new worksheet and then paste from another
application. Or when I drag a text file onto an open instance of Excel. The
"text to columns" operation I was refering to was an attempt to set the
options I wanted before the paste/import. This was the suggested fix from a
number of sites. I entered garbage data into a cell and performed a
delimited "text to columns" using a char not in the data as the only selected
delimiter.

Is there a way to just turn off the automatic parsing??

"Dave Peterson" wrote:

Is the parsing only happening after you've run data|text to columns (or opening
a text file) in that excel session (it doesn't occur right after you open excel
and your workbook)???

I'm guessing that your earlier text to columns is causing the trouble.

Put something in an empty cell (like asdf)
then do the text to columns.
Choose delimited
but uncheck all the options
and finish up
Then clean up the cell.

Then try pasting your data.



meltemi wrote:

I think I'm using Excel 2007, but I'm not sure because they hid the "Help
About" menu. There's a question mark icon at the upper right that leads to
online help, but the online help regarding how to find the version number
refers to menu items that I don't see anywhere.

How do I turn off automatic parsing for pastes or file imports? It always
does the wrong thing and parses on tabs. As suggested all over the web,
before the paste or import I tried doing a "Text to Columns" with settings
that will would correctly for the data I'm trying to import, but the import
still gets mangled.

--

Dave Peterson

.

Relevant Pages

  • Re: how do I paste or import without parsing??
    ... a text file) in that excel session (it doesn't occur right after you open excel ... online help, but the online help regarding how to find the version number ... How do I turn off automatic parsing for pastes or file imports? ...
    (microsoft.public.excel.misc)
  • Re: Can I ignore numbers and sort only text in an Excel column?
    ... Parsing means seperating. ... Excel can handle this job ... I have an Excel spreadsheet that contains 4,000 names and addresses of local ...
    (microsoft.public.excel.misc)
  • Re: IO function in Vb.Net slower than in Vb6.0
    ... The fact that there is a record delimiter is a given because of the use of ... using regex on my workstation takes approx 73 seconds. ... Parsing the same file in a line by line read using the Trim and Mid ... Although it has been an interesting exercise, I don't think that regex is ...
    (microsoft.public.dotnet.languages.vb)
  • Re: Convert PDF to Excel columns
    ... columns from PDF to Excel one by one. ... PDF and Excel ... Then load text parsing on! ... Ive copied a price list of a PDF file and need to put it back ...
    (microsoft.public.excel.newusers)
  • Re: importing fixed width text files into Excel
    ... I've used every Windows version from Excel 2.0x in the late 1980s ... spreadsheet program (IIRC, Lotus Symphony's spreadsheet - the orignal ... parsing configurations). ... opening to the macro. ...
    (microsoft.public.office.misc)