Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

Working with this:

A B "C
D"
E F "G
H

Excel 2007 opens correctly:

col1    col2    col3
A       B       C
                D
--------------------
E       F       G
                H

Excel 2010 opens like this:

colA    colB    colC
A       B       C
--------------------
D"
--------------------
E       F       G
H"

I have " selected as the text qualifier. Any ideas?

share|improve this question
    
Possible duplicate of stackoverflow.com/questions/1241220/… Bonus: they may have your solution! –  Marcus Chan Jan 31 '13 at 16:41
    
Thank you. The most important thing I got from all of that: Don't open files with the "wizard." –  Shay Jan 31 '13 at 19:55
    
What is the etiquette in a situation like this? Edit the thread to request a deletion? –  Shay Jan 31 '13 at 19:56
1  
@Shay Hmm, as long as you still have the problem and searching for another solution, I wouldn't ask for a deletion. Give it some time and maybe another clever guy will come around. –  nixda Jan 31 '13 at 20:31

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.