Windows 7 Forums

Welcome to Windows 7 Forums. Our forum is dedicated to helping you find support and solutions for any problems regarding your Windows 7 PC be it Dell, HP, Acer, Asus or a custom build. We also provide an extensive Windows 7 tutorial section that covers a wide range of tips and tricks.


Windows 7: Import .txt in Excel 2010 issue

30 Jan 2012   #1
gedinfo

Windows 7 Home Premium 32 bit
 
 
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 Images
Import .txt in Excel 2010 issue-import1.png Import .txt in Excel 2010 issue-import2.png 
My System SpecsSystem Spec
.

30 Jan 2012   #2
GEWB

32bit: XP, Win7 H.P. / 64bit: 2008R2, Win7 Pro, Ultimate / Win8.1 / Several flavors of Linux
 
 

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 System SpecsSystem Spec
30 Jan 2012   #3
gedinfo

Windows 7 Home Premium 32 bit
 
 
Issue Solved

thank you for the prompt reply.

That resolved my issue!!!
My System SpecsSystem Spec
.


30 Jan 2012   #4
GEWB

32bit: XP, Win7 H.P. / 64bit: 2008R2, Win7 Pro, Ultimate / Win8.1 / Several flavors of Linux
 
 

Quote   Quote: Originally Posted by gedinfo View Post
thank you for the prompt reply.

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

Regards,
GEWB
My System SpecsSystem Spec
Reply

 Import .txt in Excel 2010 issue




Thread Tools





Similar help and support threads
Thread Forum
How to go back from Excel 2010 64 bit to Excel 2010 32 bit
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...
Microsoft Office
Excel 2010 Template Issue
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
Microsoft Office
Import from WLM to MS Office 2010
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
Microsoft Office
Outlook 2010 - Import Windows Contacts
How to Import Windows Contacts into Outlook 2010 In order to add your current contacts from Windows 7 into your Outlook 2010 program you will need to perform the following steps: 1.) Enter you Contact Folder and Select Export. Select CVS (Comma Separated Values). Store the file on your...
Tutorials
Excel 2010 save as issue
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...
Microsoft Office
Formatting Excel 2010, Excel 2003
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...
Microsoft Office

Our Sites

Site Links

About Us

Find 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:13.

Twitter Facebook Google+



Windows 7 Forums

Seven Forums Android App Seven Forums IOS App