Excel and Tab Delimited Files Question
        Posted  
        
            by OneNerd
        on Stack Overflow
        
        See other posts from Stack Overflow
        
            or by OneNerd
        
        
        
        Published on 2010-04-16T14:34:07Z
        Indexed on 
            2010/04/16
            18:13 UTC
        
        
        Read the original article
        Hit count: 673
        
excel
|tab-delimited-text
I am encountering what I believe to be a strange issue with Excel (in this case, Excel 2007, but maybe also Excel 2003, but don't have access to it as I write this).
I can reliably convert some server data over into a tab-delimited format (been doing this for years) and then open it using Excel - no issue.
However, what seems to be happening is if I have an html <table> inside one of the fields, it looks like Excel 2007 thinks it should be converting the table into rows and columns inside Excel (not what I want). As you might imagine, this throws off the entire spreadsheet.
So question is, is there any way to set up excel to NOT do this (perhaps some setting in Excel that pertains to reading tab delimited files), or am I missing something?
Thanks.
© Stack Overflow or respective owner