Solved Import .txt in Excel 2010 issue

gedinfo

New member
Local time
5:19 PM
Messages
5
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.
 

Attachments

  • Import1.PNG
    Import1.PNG
    12.7 KB · Views: 12
  • Import2.PNG
    Import2.PNG
    23 KB · Views: 14
Last edited:

My Computer My Computer

OS
Windows 7 Home Premium 32 bit
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 My Computer

Computer type
PC/Desktop
Computer Manufacturer/Model Number
(7 different computers booting up to 10 systems)
OS
Linux Mint / XP / Win7 Home, Pro, Ultimate / Win8.1 / Win10
Other Info
Four desktops, two laptops, one notebook and one tablet
Issue Solved

thank you for the prompt reply.

That resolved my issue!!!:)
 

My Computer My Computer

OS
Windows 7 Home Premium 32 bit

My Computer My Computer

Computer type
PC/Desktop
Computer Manufacturer/Model Number
(7 different computers booting up to 10 systems)
OS
Linux Mint / XP / Win7 Home, Pro, Ultimate / Win8.1 / Win10
Other Info
Four desktops, two laptops, one notebook and one tablet
Back
Top