Import .txt in Excel 2010 issue


  1. gedinfo
    Posts : 5
    Windows 7 Home Premium 32 bit
       New #1

    Import .txt in Excel 2010 issue


    I have a .txt file that is imported into Excel using delimiters("^").
    I look at the .txt file, and do not see anything different/out of place, but when I import it into Excel 2010, some of the lines end up with a "=" attached.

    For example,

    .txt Excel 2010


    - Three monitors =- Three monitors (resulting in #NAME?)

    Why is an "=" inserted into the import?

    Thank you.

    I have attached some screenshots to demonstrate.
    Attached Thumbnails Attached Thumbnails Import .txt in Excel 2010 issue-import1.png   Import .txt in Excel 2010 issue-import2.png  
    Last edited by gedinfo; 30 Jan 2012 at 12:34. Reason: Added screenshots
      My Computer
    Quote Quote

  3. GEWB
    Posts : 1,030
    Linux Mint / XP / Win7 Home, Pro, Ultimate / Win8.1 / Win10
       New #2

    See if setting import step 3 "Column data format" to "Text" helps. Otherwise, need more information about your source material and import parameters.

    Regards,
    GEWB
      My Computer
    Quote Quote

  4. gedinfo
    Posts : 5
    Windows 7 Home Premium 32 bit
    Thread Starter
       New #3

    Issue Solved


    thank you for the prompt reply.

    That resolved my issue!!!:)
      My Computer
    Quote Quote

  6. GEWB
    Posts : 1,030
    Linux Mint / XP / Win7 Home, Pro, Ultimate / Win8.1 / Win10
       New #4

    gedinfo said:
    thank you for the prompt reply.

    That resolved my issue!!!:)
    Glad it worked for you!

    Regards,
    GEWB
      My Computer
    Quote Quote

 

  Related Discussions
I have an important program that uses a DLL that only works with Excel 2010 32 bit. I'm running Excel 2010 64 bit now -- how do I install the 32 bit version? I have the CD which has both versions on it. But when I run Setup, it gives me options that I don't understand for this limited purpose. In...
Excel 2010 Template Issue
in Microsoft Office

Hi, On one computer, when I open Excel 2010 templates it doesn't open it in Excel. It previews in my explorer window as shown in this screenshot but doesnt open but on another computer it will open as normal. http://i48.tinypic.com/2vwftpk.jpg
Hi Forum, i would like to import all my mails from wlm to outlook but when i try to do that it says something about MAPI. Ive searched on google but couldt find anything usefull so maybe you guys can help. //dalhoff
Excel 2010 save as issue
in Microsoft Office

Hi, I have a user using Excel 2010 when he opens a Excel file in our sharepoint site and does a save as it does not go to the location the file is saved the path in the save as box is his local machine. All of our users that have office 2007 do not have this issue. I have configured his trust...
Hello, I want to create a table as in the drawing below, where the first cell is table-wide (as it contains the heading common (pertaining?) to all columns and rows under it) but, and this is where I cannot get it together, where those cells are divided into several columns. It's a cinch when...
Our Sites
Site Links
About Us
Windows 7 Forums is an independent web site and has not been authorized, sponsored, or otherwise approved by Microsoft Corporation. "Windows 7" and related materials are trademarks of Microsoft Corp.

 © Designer Media Ltd
All times are GMT -5. The time now is 15:25.
Find Us